Forum Discussion

Clueless's avatar
Clueless
Regular Visitor
8 years ago
Solved

Charts from different tables

Dear All

 

I have 2 tables which I want to create a stacked bar for comparision.

 

TABLE#1

Amount - Quarter

1K - Q1

2K - Q1

3K - Q2

 

TABLE#2

Amount - Quarter

1K - Q1

2K - Q1

2K - Q2

3K - Q3

4K - Q4

 

What I want basically is a smple bar char like the one below but unfortuanlly I encountered several issues

 https://drive.google.com/file/d/1BiB0r-8XG1bg4OhQmu8epJNy_92T47lv/view?usp=sharing

 

first issue, I couldn't create a chart bar, I read online that I have to create a relationship between the tables so I did by inserting a new column as row ID in both tables.. I did that in the datasets itself (excel file) if there is better way please help me.

 

Then I was able to create a chart, but ONLY the first table has the correct sums in the Qs, the second one is WRONG.

If I select the table1 first then its sums are correct and table2 wrong, and if I select table2 first then its sums are correct and table2 is wrong

 

it's driving me crazy!

 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Clueless,

     

    New a calculated table and create relationships based on common field [Quarter].

    Quarter Table =
FILTER (
    DISTINCT (
        UNION ( VALUES ( 'TABLE#1'[Quarter] ), VALUES ( 'TABLE#2'[Quarter] ) )
    ),
    [Quarter] <> BLANK ()
)

     

    Drag [Quarter] from 'Querter Table' onto X-axis. Drag [Amount] from two data tables.

     

    Best regards,

    Yuliana Gu

2 Replies