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.
Hi,
I created a matrix table with a % calculation summing up the total per row.:
I now want to visualise this in a bar chart. I’m not getting any further than this:
It looks fine, but the calculation is different from the matrix table. In the chart every category is a % of the grand total, whereas I need it per row. In the matrix “VPD - On Time” is 88,96%, in the chart it’s 22,92%. How can I have the same as in the matrix?
In the chart calculation, I can only select "Percent of grand total":
What I actually want to see is "Percent of row total" as you can do in an Excel Pivot Table.
Many thanks!
Solved! Go to Solution.
Hi @Spidy_78 ,
I’m not certain what your data model looks like, but I have tested it based on my established data model:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Spidy_78 ,
I’m not certain what your data model looks like, but I have tested it based on my established data model:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
This does not solve the problem. Executer, lets say under LPD there should be three atributes (early, late, on time) that would sum up to 100%. It should be repeated for other executers. It becomes very easy in excel.
You can create % of grand total
https://community.powerbi.com/t5/Desktop/Percentage-of-grand-total/td-p/297356
https://community.powerbi.com/t5/Desktop/percent-of-grand-total/m-p/59029/highlight/true#M24185
It's not clear from your post just what your problem is
Help when you know. Ask when you don't!
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |