Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi there
Ok working with filtered charts and am hoping some kind soul can help me work out how to show this correctly. I have listed a current example I am struggling with:
Goal:
Issue:
For example,
I would like to see just the % of High (green) over time for 5th grade. In the stacked 100% chart the %s are showing properly as 25%, 24% and 8% for R1-R3.
When I try to change the chart to a bar chart and filter out the Low and Mid categories from the Overall Band, the COUNTS are correct, but when I try to make it into a % visually, it doesn’t work.:
When I change it to “show as % of grand total” it uses the full count (15+14+5) as the denominator
Any help or advice on how to fix this would be amazing!!!
Solved! Go to Solution.
Hi @Ayupchap
Does this acieve your reqiurement?
Just edit interaction between the two visuals above.
Best Regards
Maggie
Hi
I recommend you to create measures to reflect the correct % proficient based on selecting in a slicer more than fixing the second issue since it occurs for the feature of Power BI Desktop itself.
For example, a measure shows % proficient of R1 including low, high, mid level, then add the column about "low, high, mid" to a slicer.
Best Regards
Maggie
Hi Maggie and thanks so much for your insight
The issue I am having with the filters is that soon as I click them it takes out all the other data so the %'s show only in relation to what is left. The first graph I show was just to illustrate the correct %s but any seperated graph showing the %s for each is totally fine also.
Ideally what I would like is the ability to just show the green columns you see and hide the others without changing any of the data so hide rather than filter, this would allow the data to remain the same. Is that at all possible?
Hi @Ayupchap
Does this acieve your reqiurement?
Just edit interaction between the two visuals above.
Best Regards
Maggie
Amazing!
Thanks so much!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
User | Count |
---|---|
94 | |
90 | |
83 | |
76 | |
49 |
User | Count |
---|---|
143 | |
141 | |
109 | |
69 | |
55 |