Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Rana_Rumeel
Helper I
Helper I

Conditional formatting on the basis of more than 1 column

I need to apply Custom Font color formatting on the bases of these 2 columns.

If the value in Col 1 is between -10 and +10
If value in Col 2 is between -10 and +10
then Green Else Red

Rana_Rumeel_0-1659502139946.png

I tried following Switch condition but it is not working
#418344 is green color and #DF595C is red.

SWITCH(
TRUE(),
Col 1 <=10"#418344",
Col 1 >=-10"#418344",
Col 2 <=10"#418344",
COl 2 >=-10"#418344"
,"#DF595C"
)
2 ACCEPTED SOLUTIONS
SpartaBI
Community Champion
Community Champion

@Rana_Rumeel 

SWITCH(
TRUE(),
Col 1 <=10 && Col 1 >=-10 && Col 2 <=10 && COl 2 >=-10"#418344",
"#DF595C"
)


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

View solution in original post

@Rana_Rumeel my pleasure 🙂
Please don't forget to accept the previous message as a solution for community visibility.
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543

View solution in original post

2 REPLIES 2
SpartaBI
Community Champion
Community Champion

@Rana_Rumeel 

SWITCH(
TRUE(),
Col 1 <=10 && Col 1 >=-10 && Col 2 <=10 && COl 2 >=-10"#418344",
"#DF595C"
)


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

@Rana_Rumeel my pleasure 🙂
Please don't forget to accept the previous message as a solution for community visibility.
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors