Forum Discussion
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.
| Measue | Time Value | Program | Formatted Value |
| ACP | Q3 2024 | Organization Program | 32.00% |
| ACP | Q3 2024 | State Programs | 51.50% |
| Avg Days CPC | Q3 2024 | Organization Program | 157.4 |
| Avg Days CPC | Q3 2024 | State Programs | 134.6 |
| CPC | Q3 2024 | Organization Program | 44.50% |
| CPC | Q3 2024 | State Programs | 64.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:
| Measure | TimeValue | Column3 | Column4 |
| ACP | Q3 2024 | 32% | 52% |
| Avg Days CPC | Q3 2024 | 157.4 | 134.6 |
| CPC | Q3 2024 | 45% | 65% |
| Enroll | Q4 2024 | 14% | 12% |
| Positive Screen | Q3 2024 | 52% | 78% |
Is this possible in power BI? Any suggestion on how to achieve this?
Thanks
I would create a Rules table for that
and then apply those rules in the font color conditional formatting
3 Replies
- lbendlinSuper 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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - mitchsueNew 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.
Measure TimeValue Organization Program
(field = formatted value)
State Program
(field = formatted value)
ACP Q3 2024 32% 52% Avg Days CPC Q3 2024 154.4 134.6 CPC Q3 2024 45% 65% Screening Q3 2024 33% 49% Disenrollment Q4 2024 13% 8% Enrollment Q4 2024 14% 12% Positive Screen Q3 2024 52% 78% - lbendlinSuper User
I would create a Rules table for that
and then apply those rules in the font color conditional formatting