Forum Discussion

WhaleWatcher222's avatar
WhaleWatcher222
Icon for Helper II rankHelper II
1 year ago
Solved

Switch and Or Selectedvalue error

Hi Experts   I have a satnd alone table with  1. Actuals  2. Budgets 3. forecast - P01   or alternatovely i an trying to use the column called Dataset in my FACT Table.   I want to be able t...
Need Help
  • fahadqadir3's avatar
    fahadqadir3
    1 year ago

    Dear WhaleWatcher222, You can use Field Parameter to switch between different measures,

    For exampel when you have 3 measure, 

    1. Actuals

    2. Budgets

    3. Forecast (whatever you have in your measures)

     

    You just need to calculate Field Parameter, please review the following screenshot,

    Slicer is used to presenr the selected measure.

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

     

     

WhaleWatcher222's avatar
WhaleWatcher222
Icon for Helper II rankHelper II
1 year ago

thanks for the reply back, My issues is that when forecast - P01 is selected - i want to show the actuals for April and forecast for the other 11 months
and

When Forecast - p02 s selected - i want to show the actuals for April and May and forecast for the other 10 months,  that is where i am stuck the other bit i agree with you.