How to Filter Amount column to avoid 0.00 and blank

[schapholkar]

I have a dashboard in power bi that consists of Pie chart , Matrix and bar chart 

In filters tab on amount column I have selected Advance filter. Criteria given is amount is not blant and is not 0

still data with 0.00 is shown in report. 

Can someone help in here I have copied data as follows

InvoiceAccountName	ISOCODE	Sum of InvoiceAmount
ABC	AE	7541.49
CBX	AE	0.00
LALAL	AE	73461.87
OPI	AE	56830.41
ABBBB	AE	21594.3
DFADFASDF	AE	498.81
j;lj;ljlj	AE	3477.6
9eu	AE	5638.77
4444	AE	0.00

[Anonymous]

Hi @schapholkar ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Solution 1:
If your InvoiceAmount column is in text format you need to select the following in the advance filtering:

Solution 2:
Create a measure

Measure = IF(SELECTEDVALUE('Table'[InvoiceAmount.1]) = "0.00" || SELECTEDVALUE('Table'[InvoiceAmount.1]) = BLANK(),0,1)

Apply it to filter on this visual

After each step you need to click on the apply filter.

Best regards,

Albert He

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

[schapholkar · Accepted solution]

Hi Thanks V-heq-msft,

I realised that my column is already a measure. I tried writing measure on this too but did not work. However I changed the filter from OR to AND

before it was is not blank or is not zero 0 now I made it is not blank and is not zero 😊

it is working as of now. any other situation I shall come back for sure

[schapholkar]

if you see above rest of the columns in this metrix has filters which are working fine except the invoice amount

[Gabry]

Hello there,

The reason why rows are still displayed is because there are values present in those rows.

For instance, "cbx" may have a sum of 0.00, but it also contains "AE" in the code column. To hide the row, all columns should have blank values. Therefore, the potential solution depends on your specific requirements.

For instance, one approach could be to concatenate the name and the code columns. By doing so, you would eliminate the need for the code column, and rows with a sum of 0 amount would automatically disappear.