Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
5 years ago
Solved

How To Show Total Data İn Chart

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

 

 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    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])))

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    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])))