Help with Formatting

[Tihannah]

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?

[PhilipTreacy]

Hi @Tihannah 

You can do this using the HTML Content custom visual.

Here's an explanation how to use it

Solved: Possible to change font color of ONLY a dynamic va... - Microsoft Fabric Community

Regards

Phil

[Tihannah]

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: