Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Hello,
I have this situationSo 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?
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.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!