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've got a large dataset of volumes per each category, my table looks like this:
Date | Category | Volume |
1.01.2023 | A | 1023 |
1.01.2023 | B | 421 |
1.01.2023 | C | 241 |
1.01.2023 | D | 144 |
I would like to build up a visual that shows % of each category per day vs the total sum of the volume.
How to write a formula in Power BI to achieve this?
It doesn't work for me 🤔
Could you please provide the Measure that you have used
Looks ok. Could you please increase decimals to 2 in the format of the measure?
it is ok, if you look at grand total, however, I would like to include the same for each day, so it seems like it does not count it for each day but only for the overall period
If you want Sub totals for each day, you may try turning subtotals on in the formatting of the visual
I want to build it this way:
However, with this formula it gives me inaccurate percentages. For each day each category should give 100% as a sum, whereas here it's showing % of all per selected period of time I guess
If you could giveme the pbix file, I can explore
Hope this helps:
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 |
---|---|
114 | |
105 | |
78 | |
67 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
83 | |
70 |