blank in numeric column

[Gopinath_iyer]

Hi

I am creating a matrix view with some numeric columns and i want to show the cells with "0" value as blank.

If i replace the value then data type changes.

Is there any way to deal with this?

regards,

Gopi

[PhilipTreacy]

Hi @Gopinath_iyer 

I know you've already accepted a solution to this but I think a better way is to use a Custom Format to hide the 0's. 

This way you don't have to add a column to your data and have an unneccesary column making your file bigger than it needs to be.

To apply the Custom Format, click on the values column, then in the Ribbon enter this format string in the Format area 0;0;; and hit Enter to apply it

Read this for more info on PBI Custom Format Strings

Regards

Phil

[Kishore_KVN · Accepted solution]

Hello @Gopinath_iyer ,

Dont replace value in Power Query Editor, create a new column in Power BI Desktop with that Blank values and use it in the Matrix Visual.

For example if your data is as below:

In Power BI create new Calculated column as below:

Now drag the sales new into the matrix visual and the output with sales and sales new looks as below:

First visual is just with Sales and second visual is with Sales New. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Gopinath_iyer]

Thanks for the help

Its working fine