Forum Discussion
Conditional Formatting value in a matrix against a different source's column
I have a matrix and the value is a count of the inputs.
I want to add conditional formatting to the matrix field should the number match a value i have in a separate table.
I have created a relationship between the two sources but i cannot seem to find a way to do this.
Create a measure to count the inputs (e.g., CountOfInputs = COUNT(InputsTable[InputID])).
Create a measure to compare the count against the threshold value from the other table:
If the threshold table has one value:
MatchThreshold = IF([CountOfInputs] = SELECTEDVALUE(ThresholdTable[TargetCount]), 1, 0)If related by category or another key:
MatchThreshold = IF([CountOfInputs] = RELATED(ThresholdTable[TargetCount]), 1, 0)Optionally, create a color-returning measure:
MatchColor = IF([CountOfInputs] = RELATED(ThresholdTable[TargetCount]), "#FF0000", "#FFFFFF")Go to the matrix visual in Power BI.
Click the dropdown arrow on the values field.
Choose "Conditional formatting" > "Background color" or "Font color".
Set "Format by" to "Field value".
Choose the color measure (MatchColor) or logical measure (MatchThreshold) as the formatting field.
Apply the formatting.
3 Replies
Create a measure to count the inputs (e.g., CountOfInputs = COUNT(InputsTable[InputID])).
Create a measure to compare the count against the threshold value from the other table:
If the threshold table has one value:
MatchThreshold = IF([CountOfInputs] = SELECTEDVALUE(ThresholdTable[TargetCount]), 1, 0)If related by category or another key:
MatchThreshold = IF([CountOfInputs] = RELATED(ThresholdTable[TargetCount]), 1, 0)Optionally, create a color-returning measure:
MatchColor = IF([CountOfInputs] = RELATED(ThresholdTable[TargetCount]), "#FF0000", "#FFFFFF")Go to the matrix visual in Power BI.
Click the dropdown arrow on the values field.
Choose "Conditional formatting" > "Background color" or "Font color".
Set "Format by" to "Field value".
Choose the color measure (MatchColor) or logical measure (MatchThreshold) as the formatting field.
Apply the formatting.
Hi GingerBeardDan ,
Thank you for reaching out to Microsoft fabric community form.The approach provided by mh2587 is correct, I wanted to check if you had the opportunity to review the information provided.
Using a combination of a count measure, a comparison against the threshold (via RELATED or SELECTEDVALUE), and then applying a conditional formatting rule using either a boolean or color-returning measure. Make sure your relationship is correctly defined and that the threshold table has appropriate granularity (e.g., one row per category if that's the matching key).
Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi GingerBeardDan ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
