Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ephilip004
Frequent Visitor

Filter 0 values and blanks in Box and Whisker Chart

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?

 

 

BoxWhiskerLateralLength.PNGLateralLengthFilters.PNG

1 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!

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @ephilip004,


If you can please provide some sample data to test.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.