Forum Discussion
Combining Different Status into single visual
Hi,
I have a group of projects which have a series of dates associated with them. The projects are RAG rated based on the variances between certain dates.
There are 3 main indicators:
Indicator 1 -
- Green if date A < date B
- Amber if date A < date C
- Red if date A < date D
Indicator 2:
- Green if date E < date F
- Red if date E > date F
Indicator 3:
- Green if date H < date I
- Red if date H > date I
I want to be able to produce a table in power BI as follows:
| Project Name | Indicator 1 | Indicator 2 | Indicator 3 |
| Project 1 | Red, Amber or Green | Red or Green | Red or Green |
| Project 2.... |
I think the first indicator is confusing me most as it is not simply dependent on two dates. Do I need to calculate three different date variances and then implement a rule to decide which one should be returned?
Any help would be appreciated!
1 Reply
- v-chenwuz-msftCommunity Support
Hi @GJUDGE,
Can you give some sample data and the expected table.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.