Forum Discussion
Parameter - Swap 2 Measures
Hi All,
I have a use case to solve in PBI.
I have 4 measures
- USD
- USD 1
- Volume
- Volume 2
Now I want to design a parameter with 2 values
- USD
- Volume
Based on the selection USD the reports should show data for both the USD and USD1 measures and similarly on the Volume selection in the parameter Volume and Volume1 should be shown in the reports.
How can I achieve this in PBI.
Thanks
Hi Anonymous
Attached file has a solution for this, All i have done is create a parameter based on 4 of your measures, then create a column on top of it and use it in the slicer.
Let me know if this helps.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
1 Reply
NaveenGandhiMemorable Member
Hi Anonymous
Attached file has a solution for this, All i have done is create a parameter based on 4 of your measures, then create a column on top of it and use it in the slicer.
Let me know if this helps.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!