Forum

Hi Dick, You should connect to your master to extract data and reformat it, using power query. Attached is an example of converting your horizon...

Hi Leeanne, It can be done, but I don't see any reason for this transformation, you have the data already in a proper tabular format. All you have ...

Hi Anne, It can be done, as you will see in the attached file, but it's hard to see a functional use of that format, other than printing.

Hi Caspar, You hit the average of averages problem, see this for a description and a solution:

Hi, Make sure you do the changes in the file indicated in the query: 'C:UsersAdminDocumentsonline Training HubPractice Filespq_3.02.xlsx', save the...

Hi, Can you give more details? Which sheet is not properly formatted?

Hi Arun, Format Data Labels: Set Number format to percentage, check the box Linked to source. Label Options: press the button Reset Label Tex...

Hi Andrea, Try with Focus and Peer Group separated in 2 side by side charts. % Change should either be in a 3'rd chart or plotted in secondary axis...

Hi Mark, There is no file attached. Make sure the column names are the same in both queries, it's case sensitive.

Hi Eric, File Origin is not the problem. You can use 437, or 1252, you will have the same result, file origin will not detect the custom file struc...

Check the pivot table options, data tab: retain items deleted from source is usually set to automatic. Change to None.

Hi Linda, I see what you mean. As you already expected, drilling down will not work as you expect, until you use a DETAILROWS expression:

Hi Linda, I was not able to replicate the problem you described. Drilling into any cell returns the number of rows listed in column C - Customer...

I can see 2 reasons: -the sheet might already exist -the workbook structure might have been protected, that means no sheet can be added or delet...

Hi Linda, Make sure those queries are not just added as connections only, check the box to add it to data model also, Power BI will detect the data...