Forum Discussion
Total in Bar chart
I've checked out a few solutions to adding a bar chart with a totals column but I can't get it to work.
I have a very simple set of data with a list of activities and they have are all in a specific status -
I want to show the total and then the number of activities in specific statuses.
(My first option was to create a waterfall chart but I can't colour it in the format I want as there is no option to conditionally format the colours (and no fx button))
a bar chart is my next option but just cannot work out how to show the total column.
You will need a disconnected table with a column containing total/overall and the categories. Please see the attached pbix
6 Replies
Hard to fully understand what you are looking for can you provide a diagram of what the output should look like. Example data would also help
So I just want a bar chart like this but showing the total in a bar at the top
You could use a approach like this, but instead of date and average, you can use status and count.
Just a single total bar and then the bars showing the various status'
