Hide blank row in the Account Trial Balance

[Thang_Doan]

I got a problem to hide the blank child account on the accountrial balance.

Could I get help to solve this? 

[Anonymous · Accepted solution]

Hi @Thang_Doan 

I'd like to check with you if you want to hide the entire rows where the blank exists, or just the blank value.

If you want to hide the entire rows where the blank exists, you can uncheck “(Blank)” in the filters for this visual. 

If you just want to hide the “(Blank)” value, you can create calculated columns using “IF” or “SUBSTITUTE” DAX  as the following:

Column = SUBSTITUTE('Table'[level2], "(Blank)", "")

Column = IF('Table'[level2] = "(Blank)", "", 'Table'[level2])

In addition, you can also use “Replace Values” in Power Query to replace “(Blank)” value with “” or other text values. 

^{Best Regards,}

^{Jarvis Tang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}