Forum Discussion

sfink22's avatar
sfink22
Helper I
6 years ago
Solved

Stacked column chart with data from two tables

I have two tables that I am trying to graph on one stacked column chart. One dynamic table contains dates for existing project phases, and one is a data table that contains % time to complete the pha...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi sfink22 ,

     

    You can do like this.

    1. Get such a table by transforming(copy + append queries)

    2. Create table relationship.

    3. Create calculated columns in [Date] table.

    P1_time = 
LOOKUPVALUE(
    '%time'[Phase 1 Time],
    '%time'[Complexity], 'Date'[Complexity Rating]
)
    P2_time = 
LOOKUPVALUE(
    '%time'[Phase 2 Time],
    '%time'[Complexity], 'Date'[Complexity Rating]
)

    4. Add the calculated columns and the [Date] column to the visual.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

So are the tables supposed to be related on Complexity?

 

I would unpivot the % columns in your second table. Create a bridge table of distinct Complexity values. Create relationships on complexity columns, use the complexity column from your bridge table.

  • sfink22's avatar
    sfink22
    Helper I
    6 years ago

    Yes, they are related by complexity. By a bridge table, do you mean a table that has a single column with the unique complexity values?