Forum Discussion
Possibility to Create a Stacked bar chart using Multiples Tables
Hai Experts
I have a situation here, where i have 4 tables with key columns called date, category, ID & values. ID Is the primery key in all the 4 table.but id values are not unique it has duplicates. So i'm unable to merge it into 1 table to Visualize the data in 1 Stacked bar chart as Date in X-axis , Values in Y-Axis & Category as Legend.
So please may i know is that possible to create a Stacked bar chart with the data available in Multiple tables & suggest me best way of approach for my Situation.
Reagrds.
1 Reply
I would try a bridge table which you can then use for your axis: How to Create a Bridge Table in Power BI | phData
