Show Percentages of Week Total (not grand total) in Clustered Column Chart

[Anonymous]

I have survey response data showing responses over bi-week periods. I am trying to create a clustered column chart to show the preferred categories for that specific time period. The data values are showing as a percentage of the grand total and I would like for them to show as a percentage of the bi-week period.

In a matrix I have the option to show values as a percentage of column total, but in the clustered column chart I only have the option to show the values as a percentage of the grand total.

Is there a way that I can do this for the clustered column chart?

Thanks.

[v-yuta-msft]

@Anonymous ,

Yes, the default percentage is different in this two visuals. A workaround is that you can create measures to achieve the total week percentage and drag that measure to the cluster bar chart.

Regards,

Jimmy Tao

[Anonymous]

@v-yuta-msft ,

Thanks for your response!

Could you explain to me how to create these measures to achieve the total week percentage?

Thanks!