Forum Discussion
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...
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
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