Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Combining Table Visuals

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

 

Need Help

2 Replies

  • Avantika-Thakur's avatar
    Avantika-Thakur
    Solution Supplier
    3 years ago

    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