Forum Discussion
Stacked Column Chart : add Total column
Hello the community,
Sorry if my message has already been posted, but I am pretty sure you will find the answer quickly
Here my data :
Here the result and until here everything is fine:
What I want to do is to add a simple total column like under excel :
I already found a trick by duplicating the chart and then removing the range value.
And then to finish trying to connect the two graphics as well as possible
but I don't find this solution very convenient.
Do you have other tricks please ?
Many thanks,
Pierre
PierreL69 solution attached, here are the steps:
- unpivot your original table in power query
- create new range table from original table and added a Total row
- create relationship between two tables on Range
- add measure to check if Total then add all values otherwise simple sum
- on visual, use Range on x-axis from new table called Range and on value use measure and legend is Type
7 Replies
PierreL69 solution attached, here are the steps:
- unpivot your original table in power query
- create new range table from original table and added a Total row
- create relationship between two tables on Range
- add measure to check if Total then add all values otherwise simple sum
- on visual, use Range on x-axis from new table called Range and on value use measure and legend is Type
Thank you very much !
The final result is perfect, much more better than my trick
But is this the easiest solution to generate a total?
Because I still find it not very intuitive when you have limited knowledge about Power BI
I was hoping there would be a simple button or option to add this total.
In any case, a big thank you
