Forum Discussion
Show measure in rows
Hi Djorran,
Thank you, I followed the steps and happy to say these solution worked as long as I create the calculations I require in Power Query/Data load first. It would be nice to see the ablity to pivot including calculated measures but hopefully this will come in future releases, until then I should be able to work with this. Thank you all for your help.
Community ChampionMaking some assumptions about your data and assuming you want it pretty much exactly as you have it shown:
Given data:
Product Sales Profit
a 10 5
b 20 10
c 30 5
c 40 15
1. Create query to data "query1", edit query prior to load
2. Remove Profit column
3. Pivot column Product using Sales as value
4. Add Custom Column "Type" with value "Sales" (Sales is in double quotes)
5. Save query1
6. Create query to data "query2", edit query prior to load
7. Remove Sales column
8. Pivot column Product using Profit as value
9. Add Custom Column "Type" with value "Profit" (Profit is in double quotes)
10. Save query2
11. Edit queries
12. Pick query1
13. Append query2
14. Save query
Now you can create a visualization exactly as you have shown except that the column header for the first column will say "Type". A matrix visualization with row totals should give you your grand total.
Thank smourpre. It was an example, but your solution does help me display many of the items I want to show in this fashion
However, I was also hoping to pivot calculated measures too, I have tried using the Matrix visualisation, but I can't seem to get this to work in this way. Am I right in assuming his is currently not possible in Power BI?.