Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I currently have a matrix with measures for sales, sales estimates and success % in it e.g.
Success % | Sales | Estimated Sales |
28% | 209.47 | 748.76 |
18% | 20.57 | 115.21 |
49% | 134.36 | 272.59 |
Measures
Solved! Go to Solution.
Solved with a SWITCH(TRUE(),[MEASURE] >= 0 && [MEASURE] <= 1, "Colour"). The measure was in text format and not decimal / whole number format
Solved with a SWITCH(TRUE(),[MEASURE] >= 0 && [MEASURE] <= 1, "Colour"). The measure was in text format and not decimal / whole number format
@Niiru1 What I understand from it, that you wish to have conditional formatting for measure "Sucess %" which is in row. You can put this measure in values field and then apply conditional formatting. Conditional formatting is applies to value fields so you can put these columns in value field.
if this is not what you wanted, please share more details about your problem. thanks
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |