Forum Discussion
conditional formatting
Hello, I need to set conditional format to show 3 different colors as shown below in a small sample data but cannot figure out how to do it in Power BI. Can someone please help? Thanks in advance for your time.
tracyhopaulson, try this measure:
Formatting Color = SWITCH ( TRUE (), [Counted] = 0 && [Not Counted] > 0, "Red", [Counted] > 0 && [Not Counted] = 0, "Green", [Counted] > 0 && [Not Counted] > 0, "Yellow" )Steps to apply:
1. Conditional formatting > Background color
2. Format by = Field value
3. Based on field = Formatting Color
Instead of the color names, you can use color codes (e.g., #FF0000).
3 Replies
tracyhopaulson, try this measure:
Formatting Color = SWITCH ( TRUE (), [Counted] = 0 && [Not Counted] > 0, "Red", [Counted] > 0 && [Not Counted] = 0, "Green", [Counted] > 0 && [Not Counted] > 0, "Yellow" )Steps to apply:
1. Conditional formatting > Background color
2. Format by = Field value
3. Based on field = Formatting Color
Instead of the color names, you can use color codes (e.g., #FF0000).
Thank you so much! This works 🙂
tracyhopaulson You can click the down arrow button on the required field and then select Conditional Formatting for defining formatting as per your requirement.
Here is a detailed article if you want to learn different ways: https://www.mssqltips.com/sqlservertip/6265/power-bi-conditional-formatting-for-matrix-and-table-visuals/
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Cheers!
