How to get total variation in column chart

[Anonymous]

Hi everyone , i have created line and clusterd column  graphs based on the data.   Now i want  column based on the total value. see data set below samples 

i converted in to this its working .i  want  month variation column for total looks like 

 i want to show all the values in total column bar like below 

how to add the total colulmn already added plant value 

please any  idea . 

[VahidDM]

Hi @Anonymous 

Is the data table in the Power BI like the first image you shared?

Appreciate your Kudos!!

[Anonymous]

yes thats is my table i have shared Image only @VahidDM 

[VahidDM · Accepted solution]

I think it'd be better if you Unpivot the table in Power Query and use the new format in the report.

Otherwise, try to add and use a measure as below:

Measure = sum([overstock consumption])+Sum([new materials]).....+sum([last column])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!