Simple representation of the percentage in the bar chart

[krzysztof]

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.

Sample pbx

[Anonymous]

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]

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

Sample pbx

[Anonymous]

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

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]

@Anonymous So I can not get the chart that is in the picture?

[Anonymous]

@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 %)