Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Try filtering the matrix where # Highlight Rule = 1 in the filter pane.
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?
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |