Forum Discussion

Gian666's avatar
Gian666
Frequent Visitor
4 years ago
Solved

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 you

Need Help
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi

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

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

    Thanks

    Hari 

  • isabella's avatar
    isabella
    4 years ago

    Hi Gian666 

    You can create a new column to replace this column

     

     

    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.

4 Replies

  • Hariharan_R's avatar
    Hariharan_R
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi

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

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

    Thanks

    Hari 

      • Hariharan_R's avatar
        Hariharan_R
        Icon for Solution Sage rankSolution Sage
        4 years ago

        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


  • isabella's avatar
    isabella
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    Hi Gian666 

    You can create a new column to replace this column

     

     

    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.