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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Umaxy,

 

I'd like to suggest you add column to group your status(Non-Committed and Committed), then use this column as legend field.

 

 

Regards,

Xiaoxin Sheng

Umaxy's avatar
Umaxy
Frequent Visitor
8 years ago

So these are my options:

 

 

I am not able to add any other columns to "Column Series" or "Column Values".

 

Stage is how i sort between Planned, Committed and Noon-Committed.

 

Type is how I sort between committed, non-committed, spill, and planned.

 

Here is the visual again for referance.

 

  • 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