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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
sdas028
Helper I
Helper I

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 scenario i.e. my three scenarios are forecasts, F4 which is the first 4 motnhs of the year, F6 which is the first 6 months and F8 - eight months. I have three graphs set up to compare actuals to the forecast but I don't know how to link the visuals to the slicer for each forecast. Hopefully that makes sense...

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @sdas028

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

Using a Slicer to show different measures

5.png

 

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

View solution in original post

1 REPLY 1
v-juanli-msft
Community Support
Community Support

Hi @sdas028

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

Using a Slicer to show different measures

5.png

 

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.