Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |