Dynamically changing visualization column based on slicer selection.

[Devjeet]

Hi Friends,

How can I dynamically change visualization column based on slicer selection?

I have gantt chart in which I want to add a toggle slicer which changes the field value.

Changing the parent in the chart as per the selection.

Any trick or workaround for the same will be much appreciated. Thanks in advance!!

[Anonymous]

Hi @Devjeet ,

Could you please Accept @sirlanceohlott 's reply as the solution to make the thread closed ? More people will benefit from it.

Best Regards,
Eyelyn Qin

[Devjeet]

Thanks for the help @sirlanceohlott !!

[sirlanceohlott]

You're welcome @Devjeet, I hope this helps you get your project sorted.

Have a great day!

[sirlanceohlott · Accepted solution]

@Devjeet ,

The first thing that comes to mind would be to duplicate the visuals and when your user toggles their selection between the buttons the necessary visual is shown on the canvas.

This can be achieved through bookmarks which RADACAD has an excellent write up on that you can review here: https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive