Filter 0 values and blanks in Box and Whisker Chart

[ephilip004]

Hi,

I am using the Jan Pieters box and whisker plot to graph the distribution of lateral length measures across different oil and gas basins. I want to filter out 0 values and blanks for the value Lateral Length, which is tied to each well by a Well ID. I have tried changing the Visual Filter for Lateral Length to "is not blank" and "does not equal 0," as well as created a dummy column in my excel file to flag which lateral length values are 0 and filtering based on that. However, the box and whisker plot is still showing  minimums of 0. How do I filter out the 0 and blank values for the visual?

[v-shex-msft]

Hi @ephilip004,

If you can please provide some sample data to test.

Regards,

Xiaoxin Sheng

[ephilip004 · Accepted solution]

Did some digging into the data - turns out there were some very small values (close to 0) that showed up as 0 when hovering over the visual. I changed the visual filter to only show values greater than 20 and was able to solve the problem. Thanks!