How To Show Total Data İn Chart

[erhan_79]

Hi Dear All ;

i need your quick support about below issue .

as you will see at the below chart i am giving an info "closed value bar " and "open value bar  " with stacked chart visiual  , you can imagine like that there is "statu " column which is in the visual on the axis section , and there is value column and i put this data to value section for stacked chart visiual .

i just wan that , is it possible to create one more bar to show "total value  bar " near them on the same visiual ,  i mean in the same chart there will be "all total value  bar" , "close value bar" , and "open value bar

thanks in advance for your kind supports

[ryan_mayu · Accepted solution]

@erhan_79 

maybe you can try this workaround.

create a new table which contains all, open and close value.

create a measure

Measure = if(SELECTEDVALUE('Table (2)'[status])="open",sumx(FILTER('Table','Table'[status]="open"),'Table'[amount]),if(SELECTEDVALUE('Table (2)'[status])="close",sumx(FILTER('Table','Table'[status]="close"),'Table'[amount]),sum('Table'[amount])))