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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
hansolo
Helper I
Helper I

Donut Chart - Change Filter

The way the Donut and Pie charts filter (below) is extremely confusing in my opinion. 

 

Is there any way to override this so when a selection is made, it changes the total value of each segment in the pie chart instead of showing you the share of your selection versus the total? 

 

 

 

Capture1.PNG

1 ACCEPTED SOLUTION
wonga
Continued Contributor
Continued Contributor

@hansolo

 

Are you looking to just filter down based on the selection you made in another visual?

 

You might be looking for the "Visual Interactions" function. This is where you can choose what type of interaction a visual can have with what ever else is on the page. For visuals like donut and pie, there are 3 types of visual interactions: filter, highlight (default) and none.

 

It sounds like you want the "filter" function. In Power BI Desktop, you can find this under Visual Tools - Format once you select a visual. In Power BI Service, it's on the top ribbon.

 

Let me know if you need more information, thanks.

View solution in original post

3 REPLIES 3
wonga
Continued Contributor
Continued Contributor

@hansolo

 

Are you looking to just filter down based on the selection you made in another visual?

 

You might be looking for the "Visual Interactions" function. This is where you can choose what type of interaction a visual can have with what ever else is on the page. For visuals like donut and pie, there are 3 types of visual interactions: filter, highlight (default) and none.

 

It sounds like you want the "filter" function. In Power BI Desktop, you can find this under Visual Tools - Format once you select a visual. In Power BI Service, it's on the top ribbon.

 

Let me know if you need more information, thanks.

@wonga perfect. thank you!

@hansolo - If you want to learn about features in Power BI and watch them in action you should read through the Power BI Desktop feature updates in the Power BI blog - there is also loads of other great articles there.

 

You can finde the blog post from the May 2016 update here

 

Power BI also have a youtube channel with loads of great videos to learn features and get tips and tricks.

/sdjensen

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors