Forum Discussion

sdas028's avatar
sdas028
Helper I
8 years ago
Solved

Slicer that changes visuals

Hi, I am trying to figure out a way to do the following: I have three scenarios and I want to be able to select a scenario from a slicer and it shows me the same graphs but specifically for the scena...
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi sdas028

    I make a test with my example data according to this article. 

    Using a Slicer to show different measures

     

    selectedmeasure =
VAR myselection =
    SELECTEDVALUE ( Table1[SELECTION], "selection" )
RETURN
    SWITCH (
        TRUE (),
        myselection = "F4", [F4],
        myselection = "F6", [F6],
        myselection = "F8", [F8]
    )

    Hope this can provide you some idea to achieve your requirement.

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi sdas028

I make a test with my example data according to this article. 

Using a Slicer to show different measures

 

selectedmeasure =
VAR myselection =
    SELECTEDVALUE ( Table1[SELECTION], "selection" )
RETURN
    SWITCH (
        TRUE (),
        myselection = "F4", [F4],
        myselection = "F6", [F6],
        myselection = "F8", [F8]
    )

Hope this can provide you some idea to achieve your requirement.

 

Best Regards

Maggie