Forum Discussion

Curiosity's avatar
Curiosity
Regular Visitor
3 years ago
Solved

Swap Between Multiple Columns in Visual with Field Parameter Slicer

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

  • Curiosity's avatar
    Curiosity
    3 years ago

    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/