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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Muniba
Frequent Visitor

Donut chart on filter showing 100%

I am using the donut chart for the visibility of the percentage of the issue of my activities and it is showing data fine.However when i click from the slicer on any specifc filter(issue) it shows the pie chart on that specific value as 100 percent.However i want it to show the actual value such as if i have the slow speed 20%. so when i am clicking on the slow speed via the filter the pie chart shows 20% instead of 100%. Any solution to achieve this result?

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

Slicers and filters do what they on the tin.

They slice and filter.

If you have 5 green sweets, 3 reds sweets and 2 blue sweets then 20% are blue.

If you just have 5 green and 2 blue then 40% are blue.

If you just have 2 blue then 100% are blue.

 

You can turn off interactions between slicers and graphs but 

that will still show 5 green sweets, 3 reds sweets and 2 blue sweets 

when just blue is selected

Learn about interactions here ...

https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p... 

 

 

View solution in original post

1 REPLY 1
speedramps
Super User
Super User

Slicers and filters do what they on the tin.

They slice and filter.

If you have 5 green sweets, 3 reds sweets and 2 blue sweets then 20% are blue.

If you just have 5 green and 2 blue then 40% are blue.

If you just have 2 blue then 100% are blue.

 

You can turn off interactions between slicers and graphs but 

that will still show 5 green sweets, 3 reds sweets and 2 blue sweets 

when just blue is selected

Learn about interactions here ...

https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p... 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors