I am having trouble in getting a bar chart displaying what has been bought by financial year. The percentage should be by column total, which is perfect in the matrix visual and it looks like this:
Expected Visual in the Graph basically what I want is a bar chart displaying all of 2018, 2019 and 2020 totalling up to 100% at the bottom of the matrix.
How can I obtain that?
@alexrtz sorry not sure what you are looking for? Are you looking for bar graph in matrix visual? or you simply looking a bar graph which you can pick from visual gallery.
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
I am looking for the bar graph to display the data in the same way, so that 2019 totals up to 100% etc. The matrix is the expected output. The bar chart can only display the Grand Total percent and I need the column total...
@alexrtz did you tried 100% stacked column chart visual.
Year on Axis
Material on Legend
% Age on Value
Not sure if this is what you are looking for, although I'm still not very clear about your requirement
Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.