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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
JohannesBier
Helper I
Helper I

Filtering by Clicking on Graph

When I click on a part of my ring chart it opens the data table, I would like to have the filtering function again when I click on the ring part. Same in other graphs. Can anyone help me?

Best regards

Johannes

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @JohannesBier ,

 

Hope you are doing well.

 

According to your case description and the information provided, we may understand that You did not implement the filtering function when you clicked the Donut chart, and you want to implement this function, such as filtering the visual objects of the current page after clicking a part of the Donut chart.

 

I did the following and analyzed the possible reasons why the filtering function was not implemented when clicking the Donut chart:

1. Put Last Year Sales into "Values" and display them in categories according to Category. Put a column with a hierarchical structure, such as the Month field in this example, into "Legend".

vhuijieymsft_0-1704950785338.png

2. Next, when you select the Donut chart visual object, you can see an icon in the upper right corner.

If its background color is gray, it means that you have enabled the Drill down function. At this time, when you click on a part of the Donut chart, it will not be filtered, but the data will be displayed in descending order according to the Month hierarchy.

vhuijieymsft_1-1704950824071.png

If its background color is white, then you can click on part of the Donut chart to filter the visual objects of the current page.

vhuijieymsft_2-1704950837743.png

    

All in all, please carefully check the background color of the icon in the upper right corner of the Donut chart visual object. If it is gray, the filtering function cannot be used, and if it is white, the filtering function can be used.

 

I would be very grateful if you have more questions please provide me with more detailed data such as your Power BI Desktop files.

 

Best Regards,

Yang

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @JohannesBier ,

 

Hope you are doing well.

 

According to your case description and the information provided, we may understand that You did not implement the filtering function when you clicked the Donut chart, and you want to implement this function, such as filtering the visual objects of the current page after clicking a part of the Donut chart.

 

I did the following and analyzed the possible reasons why the filtering function was not implemented when clicking the Donut chart:

1. Put Last Year Sales into "Values" and display them in categories according to Category. Put a column with a hierarchical structure, such as the Month field in this example, into "Legend".

vhuijieymsft_0-1704950785338.png

2. Next, when you select the Donut chart visual object, you can see an icon in the upper right corner.

If its background color is gray, it means that you have enabled the Drill down function. At this time, when you click on a part of the Donut chart, it will not be filtered, but the data will be displayed in descending order according to the Month hierarchy.

vhuijieymsft_1-1704950824071.png

If its background color is white, then you can click on part of the Donut chart to filter the visual objects of the current page.

vhuijieymsft_2-1704950837743.png

    

All in all, please carefully check the background color of the icon in the upper right corner of the Donut chart visual object. If it is gray, the filtering function cannot be used, and if it is white, the filtering function can be used.

 

I would be very grateful if you have more questions please provide me with more detailed data such as your Power BI Desktop files.

 

Best Regards,

Yang

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Hello,

 

Thank you very much for this detailed solution. I was able to figure it out. I have a different version of PowerBI, so I think I don't have this icon. But now it works.

JohannesBier_0-1704954570097.png

 

 

Best regards

Johannes

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors