Combining Table Visuals

[Anonymous]

How do I combine 2 TABLE VISUALS to get measures synced up.

I have 2 different datasets which doesn't talk to each other.

I have created 2 different table visuals.

What I am looking for is: how do I combine these 2 together so I can see Measure 4, Measure 5 and Measure 6 along with Measure 1, Measure 2 and Measure 3.

I am looking for something akin to "merge" function in Power Query but at the table visual level.

I tried to create a Custom column where I concatenated "Year and Business Unit"  and created custom column and then joined both custom column (Many to many) in Power Query and created a join. But that gave me very weird answers.

Here is the pbix:

https://drive.google.com/file/d/1Ggj_tnjgxngHWPu8KPGI0QrASDL8LR43/view?usp=sharing

Any help is appreciated.
-ez

[Avantika-Thakur]

Hi @Anonymous ,

1) You can try creating two Lookup tables for Business Unit and Year and then you can create relationships of the two fact tables belonging to the two visuals with these lookup tables.

2) Then pull the Business Unit and Year columns from the Lookup tables into the table visual along with other 6 measures

Hope this helps!

Please accept the solution if this answers your query.

Thanks,

Avantika

[Anonymous]

@Avantika-Thakur Thanks but how would it work?

First set of Year and Business Unit are coming from 1 table:"Comp By Network" 

Second set of Year and Business Unit are coming from 2 different tables:"Date" and "Turnover"

I do have pbix link.

https://drive.google.com/file/d/1Ggj_tnjgxngHWPu8KPGI0QrASDL8LR43/view?usp=sharing