How to get total value in column clustererd chart

[Anonymous]

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 .

[v-easonf-msft]

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

[v-easonf-msft]

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