Forum Discussion

WhaleWatcher222's avatar
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...
  • fahadqadir3's avatar
    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!!