Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape 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.

Reply
Ayupchap
Helper III
Helper III

Issue showing the correct % proficient of a filtered group

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:

  • To show the correct % proficient of a filtered group independent of showing the other performance bands.
  • Eg if 10 students are proficient out of 100, I want to see a 10% bar or line on the chart. I don’t want to see the % of mid or low students, but they need to be included in the denominator

 

Issue:

  • I can’t figure out how to do this with filters in the charts alone.
  • Every time I try to filter down to just the “High” band, it doesn’t show the true % of the whole. As in, it’s no longer looking at Mid and Low students.
    • If I try to “show as % of grade total” it shows the count as a % of the visible sub categories (ie if HRM 2A has 10 proficient students and HRM 2B has 30, the chart would display 25% for 2A and 75% for 2B because it’s using 70 as the denominator instead of calculating the % per sub-category. It should be % of all students in 2A that scored proficient.)

 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.

hrm.jpg

 

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.:

 hrm 2.jpg

 

When I change it to “show as % of grand total” it uses the full count (15+14+5) as the denominatorhrm 3.jpg

 

Any help or advice on how to fix this would be amazing!!!

1 ACCEPTED SOLUTION

Hi @Ayupchap

Does this acieve your reqiurement?

4.png

Just edit interaction between the two visuals above.

 

Best Regards

Maggie

View solution in original post

4 REPLIES 4
v-juanli-msft
Community Support
Community Support

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?

4.png

Just edit interaction between the two visuals above.

 

Best Regards

Maggie

Amazing!

 

 

Thanks so much!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.