Forum Discussion

maserr's avatar
maserr
Icon for Helper IV rankHelper IV
6 years ago
Solved

Represent assets and liabilities

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,

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    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's avatar
    v-juanli-msft
    6 years ago

    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.

     

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.