Forum Discussion

Umaxy's avatar
Umaxy
Frequent Visitor
8 years ago

Line/Stacked Column Chart, Orginization between seperate data sets and identifying matching cases.

  Ok, so this is as far as I could get. Individually, these are the 3 visualizations I am hoping to combine.                               One column is planned, committed, non-commi...
Need Help
Umaxy's avatar
Umaxy
Frequent Visitor
8 years ago

So i performed the above example twice.

 

First to find the Items that were part of planned that made it into committed and non committed.

I then aggregated everything into one table to find the items for the other 2 columns.

 

Final Graph:

 

Lastly just need to figure out how to get the velocity line all the way across?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Umaxy,

 

You can use below measure to instead velocity column.

 

Measure =
CALCULATE ( SUM ( table[velocity] ), VALUE ( table[stage] ) )

 

Regards,

Xiaoxin Sheng

  • Umaxy's avatar
    Umaxy
    Frequent Visitor
    8 years ago
    I’ll give it a shot

    Thanks