topic How to get total value in column clustererd chart in DAX Commands and Tips

How to get total value in column clustererd chart

Anonymous — Sun, 14 Nov 2021 18:45:15 GMT

i have single datasheet name called Master . in this sheet have two column name reductionlist and value . i am trying to get total value clusterd column graph . when i use union measure getting error .

i have attached simple sample data sheet for reference

i have expained in pbi file also with expected output screen shot
Sample File

thanks in advance .

Re: How to get total value in column clustererd chart

v-easonf-msft — Wed, 17 Nov 2021 08:25:49 GMT

Hi, Anonymous

If you want to add the total column in the chart, you cannot use measure. You need create an entity table/calculated table. But once you do this, the total value of the chart will be static (not affected by filters)

sample:

New Table = VAR tab1 = FILTER ( Sheet1, Sheet1[Reduction buckets] IN { " Total Reduction", "Overstock Consumption", " xxxxx", "xxxxx" } ) VAR tab2 = ROW ( "Reduction buckeys", "Total", "Value", SUMX(tab1,Sheet1[Value] ) ) RETURN UNION ( tab2, tab1 )

In addition, you try to use 'water fall chart' to replace ‘line and clustered column chart’.

Best Regards,
Community Support Team _ Eason

Re: How to get total value in column clustererd chart

v-easonf-msft — Wed, 17 Nov 2021 08:25:50 GMT

Hi, Anonymous

sample:

In addition, you try to use 'water fall chart' to replace ‘line and clustered column chart’.

Best Regards,
Community Support Team _ Eason