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
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.
Thank you, would you happen to have the pbiz file so i can follow and try?
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
It seems like the filter is not working correctly with #Highlight rule, see below
@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
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?
