Different tables in one gragh

[ChihiroWa]

Hi! I hope someone help me.

Prepared data

・Table 1 : production volume data of Category A and B

・Table 2 : production volume data of Category C

・Table 3 : production volume data of Category D

 Contents of data

・Table1

Category	Market	Plant	Type	CY	Volume
A	ASEAN	North	xxx	2022	100
A	Europe	North	yyy	2023	200
B	Europe	North	zzz	2022	200
B	India	North	aaa	2023	300

・Table2 : no column of "Category"

Type_1	CY	Volume
bbb	2022	100
ccc	2023	200
ddd	2022	200
eee	2023	300

・Table 3 : no column of "Category"

Market	Type_2	CY	Volume
ASEAN	fff	2022	100
Europe	ggg	2023	200
Europe	hhh	2022	200
India	iii	2023	300

* all tables have each different column.

* Type, Type_1 and Type_2 : different column name but same data.

What I want to do

1. Make a slicer including Category A to D.

2. Make an area gragh  including Category A to D.

    When a slicer of 1. is chosen Category A, a gragh shows volume of Category A.

3. Make a slicer including Type, Type_1 and Type_2.

    When a slicer of 1. is chosen Category A, a slicer of 3. shows xxx, yyy, zzz and aaa.

Thanks,

Chihiro

[MFelix · Accepted solution]

Hi @ChihiroWa ,

You need to create a dimension table with the types and then make the relationship betwen the 3 tables (be aware that there is a relationship that is bidirectional., then you need to use the slicers.