Forum Discussion
rikkijp
8 years agoFrequent Visitor
Clustered Column chart with Data from two datasets
I feel like I am being dense and what I want to do is possible but I can't figure it out. I have two separate datasets in my powerbi. The first is an odata link to an onprem SharePoint list wher...
- 8 years ago
Technically you have 1 dataset (Data model) and 2 tables. You either need to merge the 2 tables into 1, or load a third table that contains a list of all of the unique team names, remove the current join and link both tables to the new table. Put the column from the third table as the axis, and then columns from the other 2 tables as your values
MattAllington
8 years agoCommunity Champion
Technically you have 1 dataset (Data model) and 2 tables. You either need to merge the 2 tables into 1, or load a third table that contains a list of all of the unique team names, remove the current join and link both tables to the new table. Put the column from the third table as the axis, and then columns from the other 2 tables as your values
rikkijp
8 years agoFrequent Visitor
THANK YOU! It was right in front of my face!