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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
learner03
Post Partisan
Post Partisan

Conditional formatting based on rules and colors

i Have following sample data-

Name timestamp Work Area order picks
abc 10-Feb A 2
abc 10-Feb B 3
abc 10-Feb A 2
abc 11-Feb A 3
dec 10-Feb A 2
dec 11-Feb C 4
dec 12-Feb C 5
dec 10-Feb A 3
ded 11-Feb B 4
ded 11-Feb C 5
ded 12-Feb C 1
ded 12-Feb B 5
fds 10-Feb A 6
fds 11-Feb B 2
fds 11-Feb C 3
fds 11-Feb B 6

and the output is as below based on sum of order picked by each person for the different dates-

akapoor03_0-1677035617114.png

I need to do conditional formatting on the order sum numbers based on in which area the person worked. If the person worked only in "A" area for that particular day then text as red, If it worked in "A" and any other area then Blue and if not in "A" then Green.

The sum of order is a measure as SUM(Table[order picks]).

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@learner03 , Create a measure like

color  =

var _m1 = calculate(distinctcount(Table[Work Area]) )

var _m2 = calculate(distinctcount(Table[Work Area]), filter( Table,Table[Work Area] = "A") ) 

return

if(_m1 -_m2, "Red", "Blue")

 

Use in conditional formatting using field value option

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Ahmedx
Super User
Super User

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/GAoVf
Screen Capture #354.png

you can write measure like this
Screen Capture #355.png

View solution in original post

6 REPLIES 6
Ahmedx
Super User
Super User

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/GAoVf
Screen Capture #354.png

you can write measure like this
Screen Capture #355.png

Ahmedx
Super User
Super User

for some reason it seems to me that it should look like the one below in my screenshot, or did I not understand something?!
Screen Capture #348.png

@Ahmedx Yes, what's the approach?

amitchandak
Super User
Super User

@learner03 , Create a measure like

color  =

var _m1 = calculate(distinctcount(Table[Work Area]) )

var _m2 = calculate(distinctcount(Table[Work Area]), filter( Table,Table[Work Area] = "A") ) 

return

if(_m1 -_m2, "Red", "Blue")

 

Use in conditional formatting using field value option

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak I have sorted this taking your lead. Thnanks for this

@amitchandak thanks but I have 3 cases- worked only in "A", worked in "A" and any other area and third is worked in area other than "A"

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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