Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF function based on a slicer

Hi,    I would like to know how to go about adding a card that would change depending on the single selection on the slicer?  For example: If Apple is selected in the slicer - this card would say ...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    If you have the selectable items used in slicer in Table[Column]:

     

    MeasureToUseInCard=

    SWITCH(SELECTEDVALUE('Table'[Column]),

    "Apple", "Fruit",

    "Banana, "Fruit",

    "Iphone", "Phone", 

    "No value selected" )

     

    The next step could be to store the values to show in the table as well:

     

    MeasureToUseInCard =

    SELECTEDVALUE('Table'[Group], "No value selected)

     

    Best Regards // Ulf

Anonymous's avatar
Anonymous
Not applicable
6 years ago

If you have the selectable items used in slicer in Table[Column]:

 

MeasureToUseInCard=

SWITCH(SELECTEDVALUE('Table'[Column]),

"Apple", "Fruit",

"Banana, "Fruit",

"Iphone", "Phone", 

"No value selected" )

 

The next step could be to store the values to show in the table as well:

 

MeasureToUseInCard =

SELECTEDVALUE('Table'[Group], "No value selected)

 

Best Regards // Ulf

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks a lot! Anonymous  I will use this for some of my other cards. For some reason, when I filtered through my slicers, the right equivalent text showed up on the card. 

     

    Patrick