Get rid of items with blank values in column chart

[KrisKolady]

Would appreciate any help with the following problem.

I have a data set which is a standard S-curve with negative to positive values, and I'm trying to limit the chart to only the items at the very extreme

So I set up a Display measure that filters out the data in the middle 

XmR LY Display = IF( [XmR CYLY Diff ABS] > [Sensitivity Value], [XmR LY], BLANK())

And it's working, but it's showing the below chart

I don't want the items that are blank to show. Any ideas?

Any help will be appreciated.

PS: I'm using dynamic formatting for my measures. Not sure if that is a factor.

Kris K

[lbendlin]

cannot reproduce.  Please check my pbix

[KrisKolady]

I might have figured out what is happening. The measure that I'm using for this chart is based on a parameter based on different measures. I think that might be the issue.

When I use the measure directly, it works as expected.

[KrisKolady · Accepted solution]

So I was using another measures as a tooltip that was used to sort the visual. That measure was causing the BLANK fields to show up. DUH!

The measure that I was using to SORT had values for all the fields.

I think this is solved.

Thanks, Kris