Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |