Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
Is it possible to create a conditional format for a measure compared to another measure?
Example
I have 2 measures displayed on separate cards.
If measure A > measure B, change colour of measure A to RED
If measure A <= measure B, change colour of measure A to GREEN
Solved! Go to Solution.
@bo_afk , Yes color measure, use in conditional formatting with field value option
Color =
if([measureA]>[measureB], "Red", "Green")
for steps refer my video
https://www.youtube.com/watch?v=RqBb5eBf_I4
or
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
Hi, @bo_afk
How would you like to display this measure , on a card or on table column?
As of now, conditional formatting is only applicable to Table and Matrix, not to Card visual.
Please refer to this document .
desktop-conditional-table-formatting
Best Regards,
Community Support Team _ Eason
@bo_afk , Yes color measure, use in conditional formatting with field value option
Color =
if([measureA]>[measureB], "Red", "Green")
for steps refer my video
https://www.youtube.com/watch?v=RqBb5eBf_I4
or
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 30 | |
| 28 | |
| 22 | |
| 21 | |
| 19 |
| User | Count |
|---|---|
| 44 | |
| 31 | |
| 18 | |
| 18 | |
| 16 |