Forum Discussion

rikkijp's avatar
rikkijp
Frequent Visitor
8 years ago
Solved

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...
  • MattAllington's avatar
    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