Variable Selection

Just a quick question and I hope this is the right title. I need to create a graph that will change from Revenue, Margin, and Cost of Sales by selecting the corresponding filter.

In the end, I have one chart that is comparing Revenue vs Budgeted Revenue when the “Revenue” slicer is selected, but changes to Margin vs Budgeted Margin when the “Margin” slicer is selected…

I remember seeing a video on this but I can’t find it. Could someone link me to the correct video on how to set this up.

Thank you!

Yes this is just about dynamic visuals.

Just need to use a combination of SWITCH/TRUE logic and also create a supporting table with all the selection options.

See some examples below

1 Like