Matrix measure more than 1 value in rows

[DavePowerBI]

I am new to Power BI and require help please, In the below Matrix visualisation I am looking to find a way to highlight in colour or similar all the counties that have more than one name under the field ID. For example, On the screenshot i have attached Country UK will be "highlighted" because ID 212 had more than 1 name. Thank you

 

[AUaero]

Unfortunately, Power BI doesn't have a lot of capability when it comes to formatting row/column headers in a matrix visual.  You can, however, create a measure to drive conditional formatting of the value in the matrix.

I've created two measures - one to count the number of users and another to flag IDs that have multiple users.

# Count Users in ID = DISTINCTCOUNT('DataTable'[Name])

# Highlight Rule = 
IF(
    HASONEFILTER('DataTable'[ID]) && 'DataTable'[# Count Users in ID] > 1, 
    1,
    0
)

I then applied a conditional formatting rule to highlight any IDs in the matrix that have more than one unique user:

This will give you the following result in the matrix visual:

If this helps, please consider accepting this response as the solution for your issue.

[DavePowerBI]

Thank you, would you happen to have the pbiz file so i can follow and try?

[AUaero]

https://1drv.ms/u/s!AtHPCBKFQogGgs05o3sG0aaIjm_kZg?e=matxao

[DavePowerBI]

Thank you for your help. I have few additional followup - I have managed to replicate your advice. How am I able to filter the matrix by the highlighted cells only for column #count users in ID? I am not able to find this option like in .xls. Also when I export the Matrix to .csv all I see is loads of  values of  1's,  Thanks

[AUaero]

Try filtering the matrix where # Highlight Rule = 1 in the filter pane.

[DavePowerBI]

It seems like the filter is not working correctly with #Highlight rule, see below

 

[amitchandak]

@DavePowerBI , You can not highlight the rows field using conditional formatting, you need use that in values

Example- color measure that you can use in conditional formatting using the field value option

Switch(True() ,

max(Table[Country]) = "UK", "Yellow",

max(Table[Country]) = "UK", "Green","Blue")

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...3

[DavePowerBI]

If highlighting is not possible on Field Name, is there anything else i can use like a measure calc or similar which will show me or add a text like multi somewhere on the Matrix if there are more than 1 Field Name under ID field?