Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In Power BI, I want to create a report table same pivot table in Excel
See the picture
How to be like that, with the format same pivot table in excel
Seet Attach file
Thank you
Solved! Go to Solution.
Hey @nmhung49
I tried and almost got as yours.
Steps Below:
1. I have used Matrix Table.
2. Arranged data as like in the First Image.
3. make sure to OFF Stepped Layout from Visual Formats.
4. Play with Values/subtotals etc..
My qustion is similar to this issue, but one more step.
What should I do if I want to do more calculations from the pivot tables. For example,
I want to compute Anne Oct expense over Sep Expense, that is 112/191
Lucie Oct expense over Sep Expense, that is 109/122
Richard Oct expense over Sep Expense, that is 142/147
...
How can I do it in Power BI?
Thanks
Hey @nmhung49
I tried and almost got as yours.
Steps Below:
1. I have used Matrix Table.
2. Arranged data as like in the First Image.
3. make sure to OFF Stepped Layout from Visual Formats.
4. Play with Values/subtotals etc..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |