How to use Filter to show hide visual in power bi?

[qqqqqwwwweeerrr]

Hi Everyone,

Hope you are doing well!!

I have doubt about show hide of the visual> Here is the below image that might help the problem easily. 

If i click on Show Slaes chart it shows sales chart now if  click on Show Quanity chart and works as intended now i want something like filter innstead of button so when i select Show Sales chart in filter current chart should pop up and if i change filter as Show Quanitity Chart that that chart should pop up and hide sales chart
here is the data for the same

Category	Sales	Quanity	Oder Month
Jeans	3000	10	Nov
Jeans	2100	8	Dec
Shirts	5000	15	Nov
Shirts	4500	15	Dec
T-Shirts	6000	20	Nov
T-Shirts	8000	30	Dec

 Thanks in Advance

[Anonymous · Accepted solution]

Hi, @qqqqqwwwweeerrr 

Based on the information you have provided, Here are my answers to your questions.

1. Importing the table you provided me into Power BI Desktop, the Report view page shows two Buttons named Show Sales Chart and Show Quantity Chart, and two Stacked column charts.

2. Customize two Bookmarks according to your requirements.

3. Just match the customized bookmark with the corresponding Button。

4. Ctrl + mouse click on the button to see the results you need.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@qqqqqwwwweeerrr , I think this can be done using field parameters instead of Bookmarks and buttons

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X/Categorial Axis: https://youtu.be/GfBrB6czByw

[qqqqqwwwweeerrr]

Hi Amit,
Thanks for your response,

But i belilve this will not solve my perpose, i tried but not able to do so. Can you please gave demo on that or steps that i can follow