Forum Discussion
DavePowerBI
3 years agoFrequent Visitor
Matrix measure more than 1 value in rows
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 fi...
DavePowerBI
3 years agoFrequent Visitor
Thank you, would you happen to have the pbiz file so i can follow and try?
AUaero
Responsive Resident
3 years ago- DavePowerBI3 years agoFrequent Visitor
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
- AUaero3 years ago
Responsive Resident
Try filtering the matrix where # Highlight Rule = 1 in the filter pane.
- DavePowerBI3 years agoFrequent Visitor
It seems like the filter is not working correctly with #Highlight rule, see below