Forum Discussion
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
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/
2 Replies
- Idrissshatila
Super User
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 👍
- CuriosityRegular Visitor
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/