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.
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
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |