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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

creating category filter for pie chart/graphics

Hi, is there a way to create a filter that you can use to choose differents categories for a pie chart or a graphic?

So for example, the idea is to have a pie chart that will show the proportion of sales by group of ages, but I want to create a way to have a type of filter that if I click on it, I will have in the same pie chart the distribution of sales by country.

Is the best way to do it with a button?

Thank you

1 ACCEPTED SOLUTION
hircinelol
Regular Visitor

Hi @Anonymous ,

 

Yes you could. Create serveral bookmarks and use bookmark navigator.

https://docs.microsoft.com/en-us/power-bi/create-reports/button-navigators?tabs=powerbi-desktop .

 

Best Regards,

Jay

View solution in original post

4 REPLIES 4
hircinelol
Regular Visitor

Hi @Anonymous ,

 

Yes you could. Create serveral bookmarks and use bookmark navigator.

https://docs.microsoft.com/en-us/power-bi/create-reports/button-navigators?tabs=powerbi-desktop .

 

Best Regards,

Jay

Anonymous
Not applicable

Yes that's what i did and it worked! Thank you

amitchandak
Super User
Super User

@Anonymous , Based on the example you mentioned in last line , I think you need field parameters

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd

Anonymous
Not applicable

Yes I saw this as a possibility but i dont have the access necessary to create field parameters. But maybe it could work with a bookmark?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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