Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is there any way I can set a greater than only rule for a conditional formatting?
Solved! Go to Solution.
Hey,
unfortunately it's not possible using the rule based conditional formatting but it can be easily achieved using the field based formatting. For this create a measure like so:
vizAid background = var currentValue = CALCULATE(SUM('Fact Sale'[Quantity])) return SWITCH(TRUE() , currentValue < 115000, "coral" , currentvalue >= 115000 && currentValue < 600000 ,"#FFFF00" , "lime" )
As you can see, you can either use named colors or a valid hexcode, this article reflects on the named colors that are supported from Power BI: https://blog.crossjoin.co.uk/2018/08/10/colour-names-supported-in-power-bi-conditional-formatting/
To assign the measure to the table or matrix visual (basically you can use this coloring on any visual that supports a "fill color" like bar charts) just follow these two steps:
1. Select the background color option from the conditional formatting dialog
2. Choose the measure for the Field value based formatting:
Then you get a table / matrix visual that will look this:
Currently it's not possible to bring the conditional formatting to Total line.
Hopefully this is what you are looking for.
Regards,
Tom
Can you provide the sample data .You can also refer https://community.powerbi.com/t5/Desktop/Conditional-formatting-on-Rows/m-p/550047?collapse_discussi...
Hey,
unfortunately it's not possible using the rule based conditional formatting but it can be easily achieved using the field based formatting. For this create a measure like so:
vizAid background = var currentValue = CALCULATE(SUM('Fact Sale'[Quantity])) return SWITCH(TRUE() , currentValue < 115000, "coral" , currentvalue >= 115000 && currentValue < 600000 ,"#FFFF00" , "lime" )
As you can see, you can either use named colors or a valid hexcode, this article reflects on the named colors that are supported from Power BI: https://blog.crossjoin.co.uk/2018/08/10/colour-names-supported-in-power-bi-conditional-formatting/
To assign the measure to the table or matrix visual (basically you can use this coloring on any visual that supports a "fill color" like bar charts) just follow these two steps:
1. Select the background color option from the conditional formatting dialog
2. Choose the measure for the Field value based formatting:
Then you get a table / matrix visual that will look this:
Currently it's not possible to bring the conditional formatting to Total line.
Hopefully this is what you are looking for.
Regards,
Tom
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |