Bar Chart to select Subset on two Values

[TheMayor]

Hi PowerBI experts,

I have been struggling with his problem for a few days trying to create a chart where I have values for 12month in a total displayed.

I want to be able to select different combinations of entity/suppliers to show a subset of that data against the total, similar to the picture attached. This graph was created in Excel.

I have 13 Excel tables , 12 of which are monthly data where the entity is the column header, and the supplier is the row header.

I also have one more table where the monthly data is aggregated into total values.

How can I achieve this problem?

Any help/pointers are greatly appreciated.

[v-danhe-msft]

Hi @TheMayor,

From your description, I want to figure out how your monthly data aggregated into total values, can you offer me more information?  I would suggest you share your Excel file if possible. If the Excel file does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.

Regards,

Daniel He

[TheMayor]

Hi @v-danhe-msft,

I sent you a private message with the Excel file. 

Thank you for your help!