Posible solutions for a dashboard with multiple buttons and data to change with each one?

[powerbinewbie3]

Hi, i need to build a dashboard that will have multiple buttons. Each button should change the measure a bar chart has for the x and another for the y. I now i can use bookmarks and hide each chart except for the correct one of each button, also i can use a measure with a switch and create a hidden slicer, so the selected value in the slicer will affect the switch measure. The issue is that i have +20 buttons so both of those options seem tedious. Is there any other way around it?

[Uzi2019 · Accepted solution]

Hi @powerbinewbie3 

You can try to create bar chart with x and y both values of field paramaeter. 

make sure you take both slicer as a tile format which will look like a button. It is fastest and easiest way if you want to display 1 chart with different option of measure.

Try below which help you to create dynamic bar chart.

https://www.youtube.com/watch?v=-nqEv2YXLsU

https://www.youtube.com/watch?v=nWgPynP9XDM

make sure your slicer set to single select.

for example like this slicer which looks like a button for you chart

I hope i answered your question!