Forum Discussion

sfink22's avatar
sfink22
Icon for Helper I rankHelper 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.

     

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
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.