Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I am working with a matrix visualization to extract data from a single table. I would like to use conditional formatting to modify the color of the font based on the prior time periods cell value rendered in that matrix. I would like to simply show costs going up or down via red/green font. I see how this can be easily done if my if my dates values were in individual dedicated columns, but they are not. Any help would be appreciated.
Solved! Go to Solution.
Hi heathawalker, try this:
1.- Create this measure:
2.- Create this measure:
3.- Insert the second measure in Conditional Formating Values:
The result is this:
I hope this can help you
Hi heathawalker, try this:
1.- Create this measure:
2.- Create this measure:
3.- Insert the second measure in Conditional Formating Values:
The result is this:
I hope this can help you
This worked great. Thanks Miguel!
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 60 | |
| 53 | |
| 41 | |
| 15 | |
| 13 |
| User | Count |
|---|---|
| 97 | |
| 83 | |
| 35 | |
| 29 | |
| 25 |