Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Total value variation column chart

Hello all ,

 

i have sample data like below  want to show total value column in graph 

 
 
 

measure : 

 

variation = sum('Master Data Base'[Value])
 
 
Master data base :
 
Reduction Buckets                               Value
 
1.overstock consumption                       4.7
2.scrap                                                    -0.6
3.supply improvements                         1.6
4.sell back oms                                       0.4
5.New materials                                     -4.6
 
Now  graph looks like 
 

 

How to get total  Values   graph like below 

 

 

 

thanks in advance. any option to do that ?  there is no option for data lable for total . 

 

 
 

 

 
  • Hi Anonymous 

     

    Download this file:

    https://gofile.io/d/NrNWmb

     

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

     

    Appreciate your Kudos!!

8 Replies

  • Hi Anonymous 

     

    Download this file:

    https://gofile.io/d/NrNWmb

     

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

     

    Appreciate your Kudos!!

  • Anonymous's avatar
    Anonymous
    Not applicable

    VahidDM  Each table argument of 'UNION' must have the same number of columns i am getting this warning 

  • Anonymous's avatar
    Anonymous
    Not applicable

    i  have  Reduction Buckets    totaly 10 list but i am selecting only 5 values 

    • VahidDM's avatar
      VahidDM
      Super User

      The number of items won't make any issue with that code.

       

      Appreciate your Kudos!!

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    VahidDM  both values  come from single table  Master data base only .  Reduction Buckets ,values its two column .