creating category filter for pie chart/graphics

[Anonymous]

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

[hircinelol · Accepted solution]

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]

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

[amitchandak]

@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]

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?