Stacked column chart, 2 fields into 1 column

[Anonymous]

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

[Daniel29195]

@Anonymous 

you want 2 measures to be stacked one on top of the other,  and the third measure standalone ? 

is that right  ? 

[Anonymous]

Correct!

[Daniel29195 · Accepted solution]

@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! 🤠