numeric measure with blank Unichar (Matrix blank line)

[Dellis81]

Hello

I have a matrix w/inserted blank lines that I thought I could use a unichar vs zero.  The measure "Blank Rows" is a if statement, and it true - currently displays a zero.   And then this "Blank Row" measure is included in the BalanceSheet measure.   What I thought I had read/watched - there is a unichar that could be substituded for zero, thus forcing a blank row inside the matrix.  The unichars I have tried all result in a error within the BalanceSheet measure.

Is there a known blank unichar that still allows a blank row, but also valid in a numeric measure.  

 Another approach - is to use change the transparency within conditional formatting.   Is there a way to format "Blank Rows" measure as transparent inside the balancesheet measure?

Always appreciate the awesome community support!

[Dellis81]

AWESOME!  Thank you!

I watched your link to excel formatting - I've been using excel most of my career - and seems there are always new things to learn.   Thank you!.

[PhilipTreacy]

Hi @Dellis81 

You can use a Custom Format String to hide the 0's.  I explain how this works here

Custom Formatting Strings in Power BI • My Online Training Hub

For example for decimal numbers you could use this Format String 0.00;0.00;;

Before applying the Format String

After applying the Format String

Regards

Phil

[Dellis81]

Oh wow - possibly a very clean and easy solution - that won't affect further calculations.   However, the format string provided, I lost the 1000's (comma) separator.   I tried a few quick ideas, but no success.

Ironically - I studied your artical in my research yesterday.   Guess, my feeble mind overlooked or was focused on something else as I glanced thru 🙂  Thank you

[PhilipTreacy · Accepted solution]

Hi @Dellis81 

Try this format string

#,##0.00;#,##0.00;;

More info on custom number formats here

Excel Custom Number Format Guide • My Online Training Hub

Regards

Phil