Forum Discussion
Solution Sage100% stacked bar chart - same legend, multiple values
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?
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
2 Replies
jthomsonThis 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
wildmight2017Advocate II
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!