Show percentage and count clustered column chart

[capko]

Hello,

I have a clustered column chart like this one:

Each bar is the COUNTA of 4 differents tables. I would like to show the numbers that are already shown and ALSO the percentage of each one with respect to the total (the same for each bar, 10829). So the first bar will show 9526 and also 87.97% (9526/10829) and so on...

Thanks !

[ryan_mayu]

@capko 

could you pls provide the sample data? how you get 10829?

[capko]

It's the total number of lines of each one of the tables (all the 4 tables have the same total)

[ryan_mayu]

so based on the chart, should be  9526/(9526+9150+4737+3102) ?

[capko]

No, the total is not based in the data in the chart. The total is 10829 for all the four bars. The first one will be then 87.97%, the second one 84.50%, third one 43.74% and the last one 28.65%

[ryan_mayu]

could you pls provide the sample data or pbix file?