Represent assets and liabilities

[maserr]

Hi there,

I have several measures on Power BI: 

- Current Assets

- Non-Current Assets

- Current Liabilities

- Non-Current Liabilities

I would like to represent in a graphic where I could be able to compare assets vs liabilities, so in the assets column I would like to see Current Assets + Non-Current Assets and on the liabilities, I would like to see Current Liabilities + Non-Current Liabilities.

Could this be possible?

I would like to achieve something similar to the screenshot attached but of course on the same visual (now they correspond to two different)

Thanks in advance,

[parry2k · Accepted solution]

@maserr how does your table looks like? Do you have something that identifies what is Assets and Liabilities, which can be used on x-axis to group these together?

[v-juanli-msft · Accepted solution]

Hi @maserr 

If you want to compare  assets vs liabilities, you can create two measure

Measure = [Current Assets]+[Non-Current Assets]

Measure 2 = [Current Liabilities]+[Non-Current Liabilities]

Or you can add a filter

Current = SWITCH(SELECTEDVALUE('Table 2'[cate]),"Assets",[Current Assets],"Liabilities",[Current Liabilities])

non-current = SWITCH(SELECTEDVALUE('Table 2'[cate]),"Assets",[Non-Current Assets],"Liabilities",[Non-Current Liabilities])

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k · Accepted solution]

@maserr how does your table looks like? Do you have something that identifies what is Assets and Liabilities, which can be used on x-axis to group these together?