Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Gian666
Frequent Visitor

zero value in the table

Hello,
I would like to avoid displaying zero values ​​in column "ImportoEURO" in this table. I would like it to be blank.

Thank youImmagine1.png

2 ACCEPTED SOLUTIONS
Hariharan_R
Solution Sage
Solution Sage

Hi

You can use below measure expression to change zero into blank.

Measure = IF(Sum(Sales)=0,Blank(),Sum(Sales))

Thanks

Hari 

View solution in original post

isabella
Microsoft Employee
Microsoft Employee

Hi @Gian666 

You can create a new column to replace this column

isabella_0-1655447755516.png

 

 

Best Regards,

Community Support Team _Isabella

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

View solution in original post

4 REPLIES 4
isabella
Microsoft Employee
Microsoft Employee

Hi @Gian666 

You can create a new column to replace this column

isabella_0-1655447755516.png

 

 

Best Regards,

Community Support Team _Isabella

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

Hariharan_R
Solution Sage
Solution Sage

Hi

You can use below measure expression to change zero into blank.

Measure = IF(Sum(Sales)=0,Blank(),Sum(Sales))

Thanks

Hari 

Thank's

Hi Gian,

  Please mark this as answer if this resolves your issues.

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors