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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors