Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
hmahmudi2
Frequent Visitor

How to swich column based on the calue of SELECTEDVALUE?

Hi all;

 

I am stacked in getting the value of SELECTEDVALUE in calculated column. The DAX formula I am using is returning blank while the same formula works and returns value when used with a measure.

The DAX formula I am using looks like following:

 

Legend = 
    SWITCH(
        SELECTEDVALUE(Metrics[Metrics Fields]),
       "'MyMeasures'[% 0-5 months]",[% 0-5 months category],
       "'MyMeasures'[% 6-23 months]",[% 6-23 months category]
    ) 

 

 

thanks

5 REPLIES 5
johnt75
Super User
Super User

It won't work in a calculated column. Columns are only calculated during data refresh and so do not take into account any slicers or filters. Why do you need it in a column rather than in a measure? Is it something you could achieve with a fields parameter ?

Thanks for the respose.

I use parameter to display the data on a map when selected in a slicer. Beside this i need to add a legend on the map that divides the displayed data into 4 categories. Any way, I need a solution to switch columns based on the selected value of the slicer.

I think a fields parameter might work, add both measures to the field parameter and then use the slicer that automatically gets generated. add the fields parameter to all visuals and it should work I think.

Thanks

That works and I have tested it. My case is a bit different. I need one parameter value to do to things. First it populate the select column/measure on the map and secondly it process and categorize the select column into a categorical feature and then add on the map as a legend value. The first works but the second does not work.

 

The only thing I can think of is to add another column to the fields parameter table, link it to whichever table is driving the categories, so that a selection of the fields parameter filters the categories.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors