topic Re: Total value variation column chart in DAX Commands and Tips

Total value variation column chart

Anonymous — Tue, 09 Nov 2021 10:59:30 GMT

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 .

Re: Total value variation column chart

VahidDM — Tue, 09 Nov 2021 11:29:41 GMT

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!!

Re: Total value variation column chart

Anonymous — Tue, 09 Nov 2021 11:32:07 GMT

@VahidDM thank you so much

Re: Total value variation column chart

VahidDM — Tue, 09 Nov 2021 11:32:57 GMT

No Worries

🙏

Re: Total value variation column chart

Anonymous — Tue, 09 Nov 2021 11:39:15 GMT

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

Re: Total value variation column chart

VahidDM — Tue, 09 Nov 2021 11:41:34 GMT

Yes, The two tables must have the same number of columns.

https://docs.microsoft.com/en-us/dax/union-function-dax

If you have a table with many columns, summarize that.

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

Appreciate your Kudos!!

Re: Total value variation column chart

Anonymous — Tue, 09 Nov 2021 11:41:53 GMT

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

Re: Total value variation column chart

VahidDM — Tue, 09 Nov 2021 11:43:55 GMT

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

Appreciate your Kudos!!

Re: Total value variation column chart

Anonymous — Tue, 09 Nov 2021 11:53:30 GMT

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