The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi I want to set different conditional formating for each matric column :
points < = 40 =RED
utilisation <=30% = RED
How to do it ?
Solved! Go to Solution.
@Anonymous , In matrix formatting, is happen for each value/measure. In conditional formatting you have choose a measure and then do it you can use rule or measure based
color measure 1 = if([points] < = 40, "RED", "White")
same way create for other and use it with field value option
refer these logs
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
@Anonymous , In matrix formatting, is happen for each value/measure. In conditional formatting you have choose a measure and then do it you can use rule or measure based
color measure 1 = if([points] < = 40, "RED", "White")
same way create for other and use it with field value option
refer these logs
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
User | Count |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |