Forum Discussion

Gopinath_iyer's avatar
Gopinath_iyer
Helper II
3 years ago
Solved

blank in numeric column

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?...
Need Help
  • Kishore_KVN's avatar
    Kishore_KVN
    3 years ago

    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!!

     

     

PhilipTreacy's avatar
PhilipTreacy
Super User
3 years ago

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