Forum Discussion

Fusilier's avatar
Fusilier
Icon for Helper III rankHelper III
2 years ago
Solved

Can't combine data from two tables on visualisation

Hope somebody can help? I have a pbix file with two different data tables: Raw Data SBC Raw Data LGA Both have a similar measure called '%fromAll xxx' I can create the chart (charts 1 and 2) I w...
Need Help
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Hello, your link does not lead to the model.

Have you created a dimension with the unique values in common of both tables? if not, I would recommend creating a table in Power Query with the unique elements of your two fact tables, then connecting it to both fact tables and using this dimension created for your visualizations.

  • Fusilier's avatar
    Fusilier
    Icon for Helper III rankHelper III
    2 years ago

    Thanks for replying.

    Sorry I don't know what you mean. I have an 'Aggregated Answers' table which is linked to the two fact tables with a one to many relationship. 

  • Fusilier's avatar
    Fusilier
    Icon for Helper III rankHelper III
    2 years ago

    I've attached another link above. Not sure why the first one didn't work?