Forum Discussion
Pass a Parameter to switch between measures
Hello All,
I have a requirement to select a value and based on the selection the visual needs to switch between 2 measures
Parameter options :- (Approved, Saved) needs to be a slicer
I have 2 measures
show_ext_end
show_ext_%
Now I need to create a measure to switch between these 2 measures based on parameter slicer
Exp = if(parameter = "approved" , "show_ext_end" , "show_ext%")
1 Reply
- amitchandak
Super User
Anonymous , hope they are part of an independent table then you can have
Exp = if(selectedvalue(Param[parameter] = "approved" , [show_ext_end] , [show_ext%])
How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M
But, I will rename measure or create measure with those names and use field parameters
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
