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.
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...
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |