Forum

Had another look at it. What if you put both the Category and Service 'is filtered' on the visual? Nothing selected in Category will hide the table...

Then I can't help you I'm afraid. Perhaps someone else.

Neat feature you are using here and I hope I've understood it correctly. Remove Service from the main table, but include Category. This will 'hide' t...

There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.

Formatting a cell as DD/MM does not turn the value into a date automatically. Real dates in Excel are sequential numbers, starting at 1 for January 1,...

OK, but then you can remove the query and steps where I pick-up the APS name and add a column with that name on all rows in the DataTable query. In th...

Oh my, that's not what I expected. I changed my mind and split the process into three steps. 1) Obtain the APS File name from the raw data. It seem...

Most entries in column B are texts where some are real dates. Texts are left-aligned and real dates are right-aligned. Can't tell why the font does...

Try this in I3: =(SUM(B3:D3)+SUM(E3:G3)/2)/H3 It combines all the intermediate calculations into one formula. However, I chose to change a formu...

Great! May I assume it works then?

Looked at the file and if I understand correctly, your Raw Data file will have different column headers (split over 3 rows, one of which is empty) dep...

You are on the right track but need to change one small reference. When you apply a conditional format to an entire column ($D:$D) the reference to th...

Could you upload a file with an example of a PT that you would want to format? And then apply the formatting manually so that we can see what you mean...

Couldn't get it to work properly with Power Pivot as I'm just not smart enough, haha! Therefor a solution in Power Query (PQ) only for what I belie...

Not sure about Power View. Do yo mean this? If you are looking for Power Pivot, and NOT working with Excel for Mac, you should find a Power Piv...