Filter column in visual to remove 0 in Power BI

[Analitika]

Hi,

I would like to ask how to filter visual that 0 will be excluded from visual. Seems filter in filter pane not corresponds. How to resolve this issue?

[Anonymous]

Hi  @Analitika ,

I created some data:

Here are the steps you can follow

1. Create measure.

Flag =
IF(
    MAX('Table'[Index1])=0&&MAX('Table'[Index2])=0&&MAX('Table'[Index])=0,0,1)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

If the result is not what you expected, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

Best Regards,

Liu Yang

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

[Analitika]

My question if some value was aproximated like 0,005 became 0. So filter doesn't see it as 0?

[Digger]

> 0.01