Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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/
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 👍
Proud to be a Super User! | |
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/
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |