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.
I've grouped projects from a dataset, with the groups reflecting what phase of the process they're in (4 total). I'm trying to create a graph to both show the phases and whether the projects are on track. The only way I can come up with doing this is nesting 4 AND functions inside an OR function, with the idea being that each AND function would correspond to on/off track for each phase. I can't seem to get this working. Here are the functions I have so far:
Sample AND Function
IF(AND('TM Dashboard'[Current Schedule Step (groups)] = "Phase 1 - Site Selection",'TM Dashboard'[Days Open]<72,"On Schedule", "Behind Schedule")
Initial (broken) Nested Function Idea
hi @lukeshaffer
if I understand you correct try SWITCH()
Schedule Status = SWITCH(TRUE(),
AND('TM Dashboard'[Current Schedule Step (groups)] = "Phase 1 - Site Selection", 'TM Dashboard'[Days Open]<72), "On Schedule",
AND('TM Dashboard'[Current Schedule Step (groups)] = "Phase 2 - Leasing & Design", 'TM Dashboard'[Days Open]<140), "On Schedule",
"Behind Schedule"
)
Sample data would really help to understand what you are doing. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thank you, @Greg_Deckler! I appreciate your patience, as this is the first time I've had a question I couldn't find answered elsewhere. I know it's got to be simple, but it's beyond me right now. Does this work for the data?
Days Open | Current Schedule Step (groups) | Schedule Status |
352 | Phase 1 - Site Selection | |
345 | Phase 2 - Leasing & Design | |
305 | Phase 3 - Permitting & Construction | |
274 | Phase 4 - Move | |
262 | Phase 1 - Site Selection | |
234 | Phase 2 - Leasing & Design | |
234 | Phase 3 - Permitting & Construction | |
196 | Phase 4 - Move | |
193 | Phase 1 - Site Selection | |
193 | Phase 2 - Leasing & Design | |
183 | Phase 3 - Permitting & Construction | |
177 | Phase 4 - Move | |
177 | Phase 1 - Site Selection | |
177 | Phase 2 - Leasing & Design | |
177 | Phase 3 - Permitting & Construction | |
176 | Phase 4 - Move | |
176 | Phase 1 - Site Selection | |
176 | Phase 2 - Leasing & Design | |
171 | Phase 3 - Permitting & Construction | |
171 | Phase 4 - Move | |
168 | Phase 1 - Site Selection | |
165 | Phase 2 - Leasing & Design | |
151 | Phase 3 - Permitting & Construction | |
119 | Phase 4 - Move | |
113 | Phase 1 - Site Selection | |
101 | Phase 2 - Leasing & Design | |
101 | Phase 3 - Permitting & Construction | |
92 | Phase 4 - Move | |
87 | Phase 1 - Site Selection | |
79 | Phase 2 - Leasing & Design | |
78 | Phase 3 - Permitting & Construction | |
78 | Phase 4 - Move | |
71 | Phase 1 - Site Selection | |
71 | Phase 2 - Leasing & Design | |
71 | Phase 3 - Permitting & Construction | |
57 | Phase 4 - Move | |
45 | Phase 1 - Site Selection | |
45 | Phase 2 - Leasing & Design | |
45 | Phase 3 - Permitting & Construction | |
45 | Phase 4 - Move | |
28 | Phase 1 - Site Selection | |
17 | Phase 2 - Leasing & Design | |
16 | Phase 3 - Permitting & Construction | |
11 | Phase 4 - Move | |
11 | Phase 1 - Site Selection | |
8 | Phase 2 - Leasing & Design | |
8 | Phase 3 - Permitting & Construction | |
8 | Phase 4 - Move | |
8 | Phase 1 - Site Selection | |
8 | Phase 2 - Leasing & Design | |
7 | Phase 3 - Permitting & Construction | |
2 | Phase 4 - Move | |
1 | Phase 1 - Site Selection | |
1 | Phase 2 - Leasing & Design |
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |