Forum Discussion
based on Slicer slection, Visual should change
Hi,
I need the ability to dynamically change the visualization type in Power BI based on the slicer selection. Currently, I am using a Line and Clustered Column chart. However, when selecting a specific element from the slicer, the visual should automatically switch to a Gauge chart. How can this be implemented?
As danextian mentioned, changing the visualization type dynamically with slicer is not possible.
You can implment workarounds though:1. Leverage bookmarks
2. Enable Personalized visuals, users can select the visualization type on their own.
3. You can over lap one visual on top of the other and change the visual background color based on slicer selection using conditional formatting. Follow the steps explained in this video
https://www.youtube.com/watch?v=b6oL29y-smY
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
3 Replies
As danextian mentioned, changing the visualization type dynamically with slicer is not possible.
You can implment workarounds though:1. Leverage bookmarks
2. Enable Personalized visuals, users can select the visualization type on their own.
3. You can over lap one visual on top of the other and change the visual background color based on slicer selection using conditional formatting. Follow the steps explained in this video
https://www.youtube.com/watch?v=b6oL29y-smY
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Hi vjnvinod
This is not possible with native slicer options directly in Power BI. Yes , I agree with tharunkumarRTK his answer. You may folllow his steps. Thanks
