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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.