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

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

      I added is not blank but still see 0 values in table.

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

        Hi Analitika 

        Please create a pbix that contains sample data but still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or dropbox and share the link in this thread. If you are using a spreadsheet to create/import the sample data instead of the manual import method, share the spreadsheet as well.