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 am trying to create a bar chart with categorical data, and within that category show the break out by a sub-category, but as a percent of the total for the category, but maintaining the bar length. So something like this. The length of the bar represents say the total cost, with the sub-categories within the bar the % by sub-category of that cost. (Note - I did the below in Tableau where I know how to achieve this)
I I Found the Following Dax Expression which kind of gets me there: (CALCULATE(SUM(Table1[Value]),FILTER('Table1','Table1'[Category]=MAX('Table1'[Category])&&'Table1'[Month]=MAX('Table1'[Month]))))/CALCULATE(SUM(Table1[Value]),FILTER(ALL('Table1'),'Table1'[Month]=MAX('Table1'[Month])))
But the problem is that it makes the bar 100% instead of maintaining the length, which can be done out of the box in Power BI anyway.
Any ideas on how I can achieve this? Thanks!
Solved! Go to Solution.
Hi @Anonymous
Sorry for my late reply. would you like to get below one?
You can show the value of % of grand total:
Pbix attached.
HI @Anonymous
you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.
I uploaded a PBIX here - https://1drv.ms/u/s!AudDnnHbK2mxjCNU6S-SsR2nwwy2?e=pd89JW
Hi @Anonymous
Sorry for my late reply. would you like to get below one?
You can show the value of % of grand total:
Pbix attached.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |