cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Graph column total percentage

Hi,

 

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 GraphExpected 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?

 

Thanks

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: Graph column total percentage

@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. 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Frequent Visitor

Re: Graph column total percentage

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...

Highlighted
Super User IV
Super User IV

Re: Graph column total percentage

@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






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors