How to exclude 0 from table visual in Power BI

[Analitika]

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?

[AnalyticsWizard]

@Analitika 

Can you try basic filtering and select any other value than 0? Does it work, are 0s excluded?

[Digger]

use AND instead of OR

[Anonymous]

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.

[Ahmedx]

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

[amustafa]

Did you try "is not" = 0?

[Analitika]

Yes but not helped.

[PijushRoy]

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]

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

[PijushRoy]

Hi @Analitika 

So in your table, it is blank value

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

[Analitika]

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

[PijushRoy]

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. 

[Analitika]

I can't, it contains sensitive data.