Forum Discussion
Helper IIICan'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 want to see (Page 1) by adding data from each table into two separate charts one for SBC and one for LBC, but I have to use the 'Aggregated answers' column in each table as the Legend. If I try and use the 'Aggregated answer' column from the Answers Aggregated table, it doesn't work (third chart) even though I have a 1 to Many relationship in place for both tables.
I also want to create a single visual that shows a line for each measure on the same visual.
Page two shows this just for Answer = Satisfied
I don't understand why this won't work. Can anybody help please?
Dropbox link to pbix file:
Hi,
PBI file attached.
Hope this helps.
7 Replies
Syndicate_AdminAdministrator
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.
FusilierI'm sorry I'm having problems with the link on google drive.
Here's a dropbox link instead:
And here's the model view:
- Ashish_Mathur
Super User
Hi,
PBI file attached.
Hope this helps.
- Fusilier
THANK YOU!
I presume you changed a single line in the measures. I would never have spottd that!
- Ashish_Mathur
You are welcome.