Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I am currently trying to implement some conditional formatting based on 3 criteria and would really appreciate some help if possible.
The 3x columns I have:
- Product Profit ($)
- Parts Profit ($)
- Margin (%)
I am trying to complete some colour coding based on the combinations of criteria below
- IF Product Profit ($) = (>0) AND Parts Profit ($) = (>0) AND Margin (%) = (>0) - should be coloured green.
- IF Product Profit ($) = (<0) AND Parts Profit ($) = (>0) AND Margin (%) = (>0) - should be coloured yellow.
- IF Product Profit ($) = (<0) AND Parts Profit ($) = (<0) AND Margin (%) = (<0) - should be coloured red.
Would really appreciate some help or guidance on this!
Solved! Go to Solution.
Try this measure
measure =
var _a= min('Table'[Product Profit])
var _b= min('Table'[Parts Profit])
var _c= min('Table'[Margin])
return
SWITCH(TRUE(),
_a>0 && _b>0 && _c>0,"Green",
_a<0 && _b>0 && _c>0,"Yellow",
_a<0 && _b<0 && _c<0,"Red")
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Try this measure
measure =
var _a= min('Table'[Product Profit])
var _b= min('Table'[Parts Profit])
var _c= min('Table'[Margin])
return
SWITCH(TRUE(),
_a>0 && _b>0 && _c>0,"Green",
_a<0 && _b>0 && _c>0,"Yellow",
_a<0 && _b<0 && _c<0,"Red")
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hello all,
I have a similar requirement wherein I need to define user's occupancy in a month based on number of projects assigned during the time period. Ex: For January month if a user has 6 projects planned between Jan 5-Jan 25, 1st project is falling between Jan 5th-Jan10th, 2nd & 3rd project between Jan 10-Jan15th and Last 3 project between Jan 16th-Jan 25th, then for the 1st condition, the timeline should be relatively free colored green, for 2nd condition, it should be medium as there's 2 projects and colored yellow and for the last 3 project it should be high colored red and all this needs to defined based on demands and start and end date of task.
Basically If one task then free = green, 2 task then medium =yellow and if user has 3 task and more than highly busy = red based on dates overlap. I need this to be visualised.
Below is the sample data.
Task Number | Users | Start Date | Complete Date |
101 | John | 1/1/2024 | 5/1/2024 |
102 | John | 6/1/2024 | 11/1/2024 |
103 | John | 6/1/2024 | 11/1/2024 |
104 | John | 6/1/2024 | 11/1/2024 |
105 | John | 12/1/2024 | 17/1/2024 |
106 | John | 12/1/2024 | 17/1/2024 |
107 | John | 18/1/22024 | 23/1/2024 |
108 | John | 18/1/22024 | 23/1/2024 |
109 | John | 18/1/22024 | 23/1/2024 |
110 | John | 18/1/22024 | 23/1/2024 |
111 | John | 18/1/22024 | 23/1/2024 |
112 | John | 18/1/22024 | 23/1/2024 |
113 | Bethany | 1/1/2024 | 4/1/2024 |
114 | Bethany | 1/1/2024 | 4/1/2024 |
115 | Bethany | 5/1/2024 | 6/1/2024 |
116 | Bethany | 6/1/2024 | 11/1/2024 |
117 | Bethany | 6/1/2024 | 11/1/2024 |
118 | Bethany | 18/1/22024 | 23/1/2024 |
119 | Bethany | 18/1/22024 | 23/1/2024 |
120 | Bethany | 18/1/22024 | 23/1/2024 |
121 | Bethany | 24/1/2024 | 30/1/2024 |
122 | Bethany | 24/1/2024 | 30/1/2024 |
123 | Bethany | 24/1/2024 | 30/1/2024 |
124 | Bethany | 24/1/2024 | 30/1/2024 |
If user a has task >=1 at a time then it shall show green,
If user has task = 2 at a time then it shall show yellow.
And if user has task > 2 at a time then red. All this shall be based on RG start & RG completion date.
If there are 5 user, each user shall have a bar showing his occupancy in either green, yellow or red based based on dates.
KIndly help. Thanks in advance.
This worked!!
Thanks so much.
@PThompson1888 , Not able to get the logic. But this logic if you can create a measure, then you can use that in conditional formatting using field value option
example
Switch( True() ,
[Percent] =1 , "Green"
[percent] <.75 , "red",
[percent] <.99 , "Yellow"
)
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
Hi @amitchandak - I have tried to make my logic more clear by updating my initial post. The criteria I would have are 'AND' rather than having the suggestion above which would only take into account one column in my data (margin percent).
Does the updated post clarify a little on what I am trying to do?
User | Count |
---|---|
77 | |
76 | |
42 | |
30 | |
24 |
User | Count |
---|---|
97 | |
91 | |
52 | |
47 | |
46 |