Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Using Parameters as Slicer 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%")

Frequent Visitor

Greetings @rasalaprashanth,


I used a slicer in that same way, only I used the SWITCH function instead of if/then and it worked for me:


I made the following measure then assigned the slicer.

Parameter_Select =


VALUES ( 'Sort_Parameters'[Parameter] ),



"Parameter1", [Measure1],

"Parameter2", [Measure2],

"Parameter3", [Measure3],

"Parameter4", [Measure4]



I had multiple measures that I needed to sort, so I put them in the 'Parameter_Select' table. You may or may not need to use SUMX.
Hope this helps.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors