Forum Discussion

GJUDGE's avatar
GJUDGE
Helper II
4 years ago

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 NameIndicator 1Indicator 2Indicator 3
Project 1Red, Amber or GreenRed or GreenRed 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-msft's avatar
    v-chenwuz-msft
    Community 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.