Swap Between Multiple Columns in Visual with Field Parameter Slicer

[Curiosity]

Hi all-

I would like to use a field parameter to swap between multiple columns in my visual. For example, say I would like to plot the Sell-In and Sell-Thru inventory on a line graph. I want my field parameter to swap between showing the Revenue for both Sell-In and Sell-Thru and showing the Quantity for both Sell-In and Sell-Thru. I've tried adding all 4 columns to a field parameter, but I would like for the swap to show two at a time. So if I select Quantity, the plot will display the Sell-In Qty and Sell-Thru Qty; and if I select Revenue, the plot will display the Sell-In Rev and the Sell-Thru Rev. I've also tried using a field parameter of a field parameter, but this became too complex.

Any help would be greatly and graciously appreciated!
Thanks,
George

[Idrissshatila]

Hello @Curiosity ,

check this may help you with your case https://youtu.be/Ty3iMTDZAA0

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Curiosity · Accepted solution]

Sorry that video doesn't help me, but I was able to solve my issue using this blog: phdata.io/blog/switching-metrics-in-power-bi/