Grand of Total in Clustered Chart

[YerlaSDU]

Hi Folks,

Could you please advise, how can I show the grand of total in percentage in clustered column chart? f.e: 17 (18%); 30 (32%); 44 (48%)

[grandtotal]

Do you want to show both label (value and %) on a clustered column chart?

I'm affraid that is not possible at the moment.
You should use a custom visual which has this feature, or try this (limited) trick:

https://community.powerbi.com/t5/Desktop/How-to-show-detailed-Labels-and-count-both-for-clustered-co...

[serpiva64]

Hi,

you can use

Show value as 

Percent of grand total

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[Tahreem24]

@YerlaSDU , Create a measure like below:

Measure =

VAR Ratio_ = CALCULATE(COUNT('Table'[Category]),ALLEXCEPT('Table','Table'[Category]))

VAR All_ = CALCULATE(COUNT('Table'[Category]),ALL('Table'))

RETURN DIVIDE(Ratio_,All_)

[YerlaSDU]

@Tahreem24 

I need to show total number and grand total % both together, not only percentage

[Tahreem24]

@YerlaSDU Sadly, that's not quite possible as of now.