Hi Team,
I want to know how to do conditional formatting in power bi when dating in the column where visual is Matrix table.
for example
keyword ABC - is greater than any of date then it turns into dark green if it is lower than the highest one then light green if it is a lower value than among both the date then it converts to red color.
I want format like below:
Thanks,
Arvind
Hi @arvindyadav ,
Try this:
Measure 3 =
RANKX (
ALLEXCEPT ( 'Table', 'Table'[Account Manager] ),
CALCULATE ( MAX ( 'Table'[Profit] ) ),
,
DESC,
DENSE
)
Hope it helps.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @arvindyadav ,
Try this:
Measure 3 =
RANKX (
ALLEXCEPT ( 'Table', 'Table'[Account Manager] ),
CALCULATE ( MAX ( 'Table'[Profit] ) ),
,
DESC,
DENSE
)Hope it helps.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @arvindyadav ,
Try this:
1. Create a measure.
Measure =
IF (
MAX ( 'Table'[Value] )
= CALCULATE ( MAX ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Keyword] ) ),
1,
IF (
MAX ( 'Table'[Value] )
= CALCULATE ( MIN ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Keyword] ) ),
2,
0
)
)2. Set conditional formatting of Value.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @arvindyadav ,
I'm afraid that Power BI doesn't exactly support it now. However, one workaround is below:
Don't need any measure. Just refer to this document to set Conditional formatting of Value.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Icey ,
Not worked on my table.
If you see Akshay row it not reflecting date wise.
I guess it takes all over the table value and applies based on the table value.
Actually I want Individual Performance of all employee.
Thanks,
Arvind
Hi @arvindyadav ,
Try this:
1. Create a measure.
Measure 3 =
RANKX (
ALLEXCEPT ( 'Table (2)', 'Table (2)'[Keyword] ),
CALCULATE ( MAX ( 'Table (2)'[Value] ) )
)2. Set conditional formatting of Value.
Then, you can get this:
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
