100% stacked bar chart - same legend, multiple values

[jthomson]

Hi,

I'm having trouble getting a visual running for the data I want to show - I've got ten different csv's which are showing a bunch of different data, and the only thing they all have in common is a supplier column, the only relationships are one to many between each csv and a table I've made through merging the lot of them on the supplier column and removing all the duplicates. I've got a simple measure on each of them counting the rows which I'm feeding into cards to give an overall total of each, but I want to create a stacked bar chart to show the percentage breakdown by supplier of each measure, so something like this:

I can get one measure in fine, but only one - is there a way to get this to work in just the one visual, or some custom visual that has this functionality?

[jthomson · Accepted solution]

This can be ignored now, I've got it working by the needlessly convoluted method of adding a custom text column to every CSV with the name of each measure, appending all the CSV's together, making a new countrows measure on the new query and using the custom column as the axis

[wildmight2017]

Just faced the same issue - would you mind providing a sample pbix? or at least a formula to get that countrows? 

How does time work in this instance? Just a slicer outside the chart?

Thank you!