Forum Discussion
Anonymous
7 years agoNot applicable
Conditional Highlighting in a Matrix and a Measure to Check Those Conditions
I have the below measure:
All of the columns to the right of 'Project' are measures that only sum the gender/ethnicity in the column.
I'm trying to figure out how I can accomplish the conditional highlighting and indicator. I would like...
- The gender cell to be highlighted if that cell is <= 10% of the Total Project Amount
- The ethnicity cell to be highlighted if that cell is <= 20% of the Total Project Amount
- The indicator cell to be populated/highlighted if either of the above are true
Thanks!
2 Replies
- v-chuncz-msftCommunity Support
Anonymous ,
You may try SWITCH and SELECTEDVALUE to add measures and then use Color formatting by field value.
https://community.powerbi.com/t5/Desktop/Subtotal-Percentages/m-p/313658#M139139
- AnonymousNot applicable
Hi v-chuncz-msft ,
Would you mind providing some additional detail? I'm not clear on how thoe functions in conjunction with the linked post would provide the desired functionality.
Thanks!