Forum Discussion
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?
regards,
Gopi
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!!
3 Replies
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!!
Thanks for the help
Its working fine
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
