Forum Discussion

Tihannah's avatar
Tihannah
Resolver II
2 years ago

Help with Formatting

Not sure if this is possible, but thought I would ask.

 

I have a dynamic measure based on button selection that says

If Actual is selected, then Actual

If vs Budget is selected, then Budget Variance

If vs Prior Year is selected, then Prior Year Variance.

 

I would like to format Budget and Prior Year variances with the Red and Green, but not Actuals. Is this possible since they are all built into the same measure?

Need Help

2 Replies

    • Tihannah's avatar
      Tihannah
      Resolver II
      2 years ago

      I'm not sure how this would work in my problem. There is no text in what I am displaying. I have a matrix table showing a trailing twelve months of data. When I select one of the buttons on the right, the data changes to display that. So I want to display the variances as positive or negavtive, but with no impact to Actual even though they are all built into the same measure with the following dax: 

      MthlyTrend Selection = IF(Buttons[Button_Slicer]="Actual",[Act_Total],IF(Buttons[Button_Slicer]="vs Budget",[Budget Var],[ACT_PY_Var]))
       
      As you can see in September, Actual may sometimes be a negative amount, but I do not want that to display in RED. Only the variances to Actual.
      Table Examples below: