Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
Proud to be a Super User!
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:
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |