Percentage visual level filter not working as expected

[VenkatM]

I would like to get help on the following points on visual level filter on percentages.

1. I not able to filter using "is" and "is not". I am getting blank table when I apply filter with "is" or "is not" id if the percentage values are present in the table.

       I have the measure example as Measure = DIVIDE(SUM(Sheet1[column1]),SUM(Sheet1[Sale Amount]),0)

       Format is set to percentage and two decimal places.

2. filter value automatically changes to percentage. For example if I enter 1, the filter changes to 100%. Is there a way it will take the value as 1% instead of 100? 

Is there any suggestions on the above?

Thanks in advance

[VenkatM]

Thanks for the information.

Is there any solution for the point number 1?

The rows are not still filtered for "is" and "is not" condition in visual level filter.

[johncolley]

Using decimals here should work as well. If you are still having issues you might want to share some example data.

[VenkatM]

I have included some sample pbix file.

Please check the visual level filter set to 83.33% on one of the measure but it is not working.

You will see the data when the filter is cleared and notice that the 83.33% is present in the data.

https://drive.google.com/file/d/19Brk1P9AaleGGgxt6DqE7dsK1nyKAeKt/view?usp=sharing 

[johncolley · Accepted solution]

Hi @VenkatM ,

Thank you for sharing this. Very annoying - but Power BI seems to be struggling to identify the number of decimals in the measure when using the 'IS' filter. So while we can it's to 4 decimal points i suspect somewhere behind the scenes it is registering more than that so it's not an exact match.

A work around is to create the column in Power Query first. Below is the code to create the column and set the decimals to 4.

Then use this column in the table and set the IS filter to .8333 as you can see below it filters the table as required.

If this answer solves your problem please mark it as a solution!

[VenkatM]

John, Thanks for the help narrowing down the issue. This helped me.

I had some some complex measures for percentages. So I used measure for rounding and it worked too.
for example:
RoundMeasure = ROUND([Percentage Measure],4)

[johncolley]

Hi Venkat,

The value is formatted as a % but Power BI still views it as a decimal value. 

For example if you want to filter the table to values of 75% you need to enter 0.75 if the filters menu. For 1% you'll need to enter 0.01.

If this answer solves your problem please mark it as a solution!