I am looking for some help regarding a bar chart that shows the percentage of the count of a type of subcategory (selected in my filter) based on the total number of a category specified in time. Basically the data I have looks like this:
And I want to apply the following filters:
|Filter on Category||A|
|Filter on Subcategory||x|
|Filter on week||[All]|
After which I want to show the percentage of counted "x" relative to the total count of "A" per week, i.e. a result (in a bar graph that basically shows:
|Category||Subcategory||Week||% of Category|
So far, my attempts have not gotten me far (not very experienced yet) and when using metrics to calculate totals and percentages, the Category "A" changes with the filter "x". In other words I keep getting 100% as an outcome in the end. Could someone help me with this?
Thanks a lot!
Solved! Go to Solution.
This is good, it is working in matrix table, but not working for bar chart.... here is the scenario:
i have data of around 10k records with consists of name, months, multiple subcategories (poor, good, very good, excellent) in column1
My question is i want to display month wise % of good, poor, very good, excellenet in bar chart.. i wnat to display & on each bar.
Share data in a format that can b pasted in an MS Excel file. Ensure that there is also a Year column (along with Month column) in your dataset.
Try this measure
Hope this helps.
Thanks, for my specific question this works as well.
Difference with the solution of @Zubair_Muhammad is that with that solution I can select multiple filters (i.e. a second category related to the above data), while keeping the "base value" the same (i.e. the number of "A"'s). With your solution it is possible to select an additional filter, which than becomes the new "base value".
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.