+/- sign on matrix for hierarchy levels with no values

[Anonymous]

Hello,
I have this situation
So in this example I have no values under a and some values under b. On my matrix I would like to have the option to display what is under b using + sign, but the only way I can achieve this is to have a + sign next to "a" too. I would like to have a plus sign only next to b, and not next to "a". Is there any way I can do this?

[mwegener]

Hi,

i think it's not possible, because Power BI not really supports ragged hierarchies.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[lc_finance]

Hi @Anonymous ,

did you try using the FORMAT function?

It works like in Excel and you can find more about it here.

FORMAT allows you to change the format of a number, for example adding + when the number is positive.

Let me know if this helps you,

LC

Interested in PowerBI and DAX templates? Check out my template at www.finance-bi.com