Having problems in Percentage of Grand total in a Clustered Column Chart

[sushantj]

Hello All, 

I want to extract data from google sheet and create a chart (which i already have done, please see the screenshot for the same). 

The bars show the count of something for a particular month. The screenshot 1 shows the data for the month of May and June. 

The problem is - The percentage as shown in the screenshot is according to the grand total of both the months (May and June). I want to show the monthly data. As in the blue bar in the month of May should be the percentage of count of things according to the grand total of June and not according to the grand total of both May and June. 

Note: If i filter out the month of May, then only the data for the month of June is considered (See screenshot 2 for the same). But i want to show the data for both the months together. 

Please help me with this.

s

[v-qiuyu-msft · Accepted solution]

Hi @sushantj,

You can create a measure like below:

Measure = DIVIDE(COUNTROWS('Table1'),CALCULATE(COUNTROWS('Table1'),FILTER(ALL(Table1),MONTH('Table1'[Date])=MONTH(MAX('Table1'[Date])))))

Best Regards,
Qiuyun Yu

[sushantj]

Hi @v-qiuyu-msft,

Found the solution and understood the formula for the measure. 

Thanks a lot for your help.

Regards,

Sushant Jadhav

[sushantj]

Hi @v-qiuyu-msft,

I have two questions on this,

1) I am not getting percentage sign besides the numbers, did you do something else to make that happen?

2) Can you explain how the formula in the measure works? I am having a hard time understanding it!

Regards,

Sushant Jadhav