Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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])))
Proud to be a Super User!
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])))
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
104 | |
77 | |
71 | |
50 |
User | Count |
---|---|
145 | |
108 | |
107 | |
90 | |
65 |