Forum Discussion
Stacked column chart, 2 fields into 1 column
Hi
I would like to provide a visual for assets vs liabilities & equity, I have 3 measures that pull in numbers for all 3 but unsure how to group the liability and equity and then stack ontop of eachother vs assets
Anonymous
output
in both outputs,
your table should be structured like this :
so liability, equity, assets, are values in a column,
and you then create a column that groups liability and equity, and another group that groups assets.
NB: the visual on the right, can only be done with the latest power bi update and you need to enable on - object interaction from the preview features.
let me know if this helps.
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
3 Replies
Anonymous
you want 2 measures to be stacked one on top of the other, and the third measure standalone ?
is that right ?
Anonymous
output
in both outputs,
your table should be structured like this :
so liability, equity, assets, are values in a column,
and you then create a column that groups liability and equity, and another group that groups assets.
NB: the visual on the right, can only be done with the latest power bi update and you need to enable on - object interaction from the preview features.
let me know if this helps.
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠