Forum Discussion

Anno2019's avatar
Anno2019
Icon for Helper IV rankHelper IV
3 years ago
Solved

Slicer to change column value selected

Hi Guru's Need some Dax help. I need to create a column that will change the values based on the value selected in the slicer. Table'Region Name' is created to be used as the slicer. based on the...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    Anno2019 

    We can write a measure to return the Region Owner like this.

     

     

    Region Owner = 
VAR _Region = SELECTEDVALUE ( 'Region Name'[Regions] )
RETURN
    SWITCH(
        _Region,
        "East", SELECTEDVALUE ( Data[Region East] ),
        "West", SELECTEDVALUE ( Data[Region West] ),
        "South", SELECTEDVALUE ( Data[Region South] ),
        "North", SELECTEDVALUE ( Data[Regioin North] )
    )

     

     

    Then set a filter on the visual to [Region Owner] is not empty.

     

    I have attached my sample file for you to look at.

     

  • Anno2019's avatar
    Anno2019
    3 years ago

    So fast, you are awesome,

    Thanks jdbuchanan71 , worked like a charm.

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
3 years ago

Anno2019 

We can write a measure to return the Region Owner like this.

 

 

Region Owner = 
VAR _Region = SELECTEDVALUE ( 'Region Name'[Regions] )
RETURN
    SWITCH(
        _Region,
        "East", SELECTEDVALUE ( Data[Region East] ),
        "West", SELECTEDVALUE ( Data[Region West] ),
        "South", SELECTEDVALUE ( Data[Region South] ),
        "North", SELECTEDVALUE ( Data[Regioin North] )
    )

 

 

Then set a filter on the visual to [Region Owner] is not empty.

 

I have attached my sample file for you to look at.

 

Anno2019's avatar
Anno2019
Icon for Helper IV rankHelper IV
3 years ago

So fast, you are awesome,

Thanks jdbuchanan71 , worked like a charm.