cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
krzysztof Regular Visitor
Regular Visitor

Simple representation of the percentage in the bar chart

Hi, I need to present% share in a column chart.

 

1. If I click on the values in the graph and I mark "Show value as -> Percent of grand total" shows me the participation of% groups but taking into account all months and I want in a given month.

 

2. If I change the visualization to "100% stacked column chart" then the values are correct but the Y axis is incorrect, I want the size of the bars to show the sales volume.

 

1.PNG

 

Sample pbx

5 REPLIES 5
tejaswidmello Established Member
Established Member

Re: Simple representation of the percentage in the bar chart

Hi  @krzysztof 

 

Can you try using Line and stacked Column chart in your case.?

 

If the issue still exist, than would you mind in sharing your data with me?

 

Thanks,

Tejaswi

krzysztof Regular Visitor
Regular Visitor

Re: Simple representation of the percentage in the bar chart

Hi @tejaswidmello , unfortunately "Line and stacked Column chart" is not appropriate. I provide you with data:

Sample pbx

tejaswidmello Established Member
Established Member

Re: Simple representation of the percentage in the bar chart

Hi @krzysztof ,

 

I tried  to create a measure which Provide us the values you want. but then I noticed that since  summation of all Group percentages in each month comes out to be 100%, therefore the Stacked bar will always shows what it is showing now.

 

For example.  ( below screesnhot shows the % of all Group on Monday July,01

 

Capture 1.PNG

 

Therefore your stacked bar also shows the % of grand total, where grand total is always 100 %

 

The only correct way to show this on the graph is the top right Graph in your report.

 

 

Or you can show the Top left bar graph with DAX  Measure in a Tooltip so when a user hover over it, they will able to see the % count for each of the group in each month.

 

 

 

Thanks,

Tejaswi

krzysztof Regular Visitor
Regular Visitor

Re: Simple representation of the percentage in the bar chart

@tejaswidmello So I can not get the chart that is in the picture?1.PNG

 

tejaswidmello Established Member
Established Member

Re: Simple representation of the percentage in the bar chart

@krzysztof 

 

What is Y-axis in your picture above?

 

The only way i think is somethign like this in the screesnhot below:( hover over the bar to get the %)Capture 2.PNG

 

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,590)