Forum Discussion
Creating a stacked chart from two separate tables
Morning I am trying to create a stacked bar chart, using data from two different tables. But I am having trouble getting it in the format that I need. I have attached some sample data and below is a...
Anonymous , Create common dimensions Plan and metric and join them with your tables, and use in visual
Metric= distinct(union(distinct(Table1[Metric]),distinct(Table2[Metric])))
Plan= distinct(union(distinct(Table1[Plan]),distinct(Table2[Plan])))
amitchandak
Super User
Super UserAnonymous , Create common dimensions Plan and metric and join them with your tables, and use in visual
Metric= distinct(union(distinct(Table1[Metric]),distinct(Table2[Metric])))
Plan= distinct(union(distinct(Table1[Plan]),distinct(Table2[Plan])))
Thanks for this, I should have said I am new to PBI so not really sure what I do with the above. I assume they are measures??