Clustered Column Chart with two data sets

[johnv]

I am relatively new to Power BI and am trying to display some survey results in a bar chart. I have two seperate data sources for two seperate groups of people. The survey questions asked the user to give a rank from 1 to 5 to a group of questions. The bar charts display the rank given along the x axis and a count of how many people chose each rank. I am able to create seperate bar charts that show the data but when I try to do a clustered bar chart it shows up as a count for one group of data (correctly) and a total for the other even though both are set to be counts. I think it has something to do with the Axis fields but I do not fully understand how these work.

Clustered Column ChartSeparate Bar charts

[v-chuncz-msft · Accepted solution]

@johnv 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/One-slicer-for-two-tables-M-M/td-p/523095

[Anonymous]

Hi

Make sure to use not only the Axis but also the legend to do the break-down.

Thank you

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com

[johnv]

That does not seem to help my issue. If I have two Axis and two value data sources, it won't even let me put anything in Legend.

[Anonymous]

Hi John 

Do you have two tables on this model?

Is there an active relationship between these two tables?

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com