Forum Discussion

GingerBeardDan's avatar
GingerBeardDan
Regular Visitor
1 year ago
Solved

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 relatio...
Need Help
  • mh2587's avatar
    mh2587
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.