Forum Discussion
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 Vari...
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
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: