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

     

     

Kishore_KVN's avatar
Kishore_KVN
Solution Sage
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!!

 

 

  • Gopinath_iyer's avatar
    Gopinath_iyer
    Helper II
    3 years ago

    Thanks for the help

    Its working fine