Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
2 years ago

How to exclude 0 from table visual in Power BI

Hi.

 

I need remove 0 from visual table in Power BI. Here how it looks like:

 

I added filter on this visual:

But still see many 0. How to resolve this case?

Need Help

12 Replies

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi Analitika 

    Looks 0 haveing some decimal points which are not showing in visual.
    Increase the decimal points TWO and check
    If require, please pul less than = 1 and greater than = 1 



    Let me know if that works for you


    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      2 years ago

      Even I changed to show 15 numbers after decimal, I still see 0.

       

      • PijushRoy's avatar
        PijushRoy
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Hi Analitika 

        So in your table, it is blank value


        f your requirement is solved, please make THIS ANSWER a SOLUTION

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    please tell me if this is an explicit measure in your column or not?
    and also, you can show the entire matrix?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Analitika ,

    If it is a measure or calculate column, please Please set the return condition to Blank() not 0.
    If it is a column in the datasheet, you can replace the value of this whole column in Power Query:


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