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 !
could you pls provide the sample data? how you get 10829?
Proud to be a Super User!
It's the total number of lines of each one of the tables (all the 4 tables have the same total)
so based on the chart, should be 9526/(9526+9150+4737+3102) ?
Proud to be a Super User!
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%
could you pls provide the sample data or pbix file?
Proud to be a Super User!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
78 | |
69 | |
55 | |
55 |
User | Count |
---|---|
200 | |
104 | |
85 | |
80 | |
77 |