Forum Discussion

asjones's avatar
asjones
Helper V
3 years ago

Field Paramer for Multiple Fields

I have a Field Parameter setup for budget types (measures), when selecting a budget from the field parameter slicer how do I also have not just budget measure sawp but also the assocated variance columns change based on budget type selected?


I want a table visual Actuals, Budget, var $ and var %. If I change the budget type I need the varainces to chagne also. Tried making a measure variance using the Bduget type vs Actuls but that did not work.

 

any thoughts?

thanks

Alan

 

 

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    Hi asjones 

     

    What you would need to do is have a filter which would change the budget type.


    Then in your measure you would need to switch it based on the filter selection?