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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.