Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
mitchsue
New Member

PowerBI Matrix - Unable to do some conditional formats on values

I am trying to do conditional formatting on a matrix. 

 

Its not just based on a value (like high or low), it's comparing values from the same table column [formatted value].  And not all rows have the same rule on how to highlight the value.  Some are ">", others are "<" .

 

Here's an example of my data in table:  Note:  The Formatted value is a measure to present data as either a decimal or percent.

MeasueTime ValueProgramFormatted Value
ACPQ3 2024Organization Program32.00%
ACPQ3 2024State Programs51.50%
Avg Days CPCQ3 2024Organization Program157.4
Avg Days CPCQ3 2024State Programs134.6
CPCQ3 2024Organization Program44.50%
CPCQ3 2024State Programs64.80%

 

The rules I need to get to is as follows:

if measure = ACP if Column3 is < than Column4 Then highlight red Else No Highlight
if measure = Avg Days CPC if Column3 is > than Column4 Then highlight red Else No Highlight
if measure = CPC if Column3 is < than Column4 Then highlight red Else No Highlight
if measure = Enroll if Column3 is < than Column4 Then highlight red Else No Highlight
if measure = Positive Screen if Column3 is > than Column4 Then highlight red Else No Highlight

 

And Here's an example of how it should be presented in matrix:

MeasureTimeValueColumn3Column4
ACPQ3 202432%52%
Avg Days CPCQ3 2024157.4134.6
CPCQ3 202445%65%
EnrollQ4 202414%12%
Positive ScreenQ3 202452%78%

 

Is this possible in power BI?  Any suggestion on how to achieve this?  

Thanks

1 ACCEPTED SOLUTION

I would create a Rules table for that

 

lbendlin_0-1745173834543.png

and then apply those rules in the font color conditional formatting

 

lbendlin_1-1745174574392.png

 

View solution in original post

3 REPLIES 3
mitchsue
New Member

Thank you for your reply.  Below is a table on how I need the data to be represented in the matrix.  Like I said above, there are different rules based on the measure.  Just a note on the 'formatted value'  = that is a measure that just formats the value in either percentage or decmimal, based on the measure.  

 

MeasureTimeValue

Organization Program

(field = formatted value)

State Program

(field = formatted value)

ACPQ3 202432%52%
Avg Days CPCQ3 2024154.4134.6
CPCQ3 202445%65%
ScreeningQ3 202433%49%
DisenrollmentQ4 202413%8%
EnrollmentQ4 202414%12%
Positive ScreenQ3 202452%78%

I would create a Rules table for that

 

lbendlin_0-1745173834543.png

and then apply those rules in the font color conditional formatting

 

lbendlin_1-1745174574392.png

 

lbendlin
Super User
Super User

yes. possible - just don't try to do that with the formatted text.  Have a separate measure that produces the font color based on the actual data and your rules.  You will need to materialize your measures to compare them.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors