Forum Discussion
Page Level Filter for Value Range
Hi wmorris20
Have you tried the new Numeric Range Filter that was released in the March update?
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-slicer-numeric-range/
You will have to turn it on in your options and I don't think it is live in the service yet (won't be far away)
Hi wmorris20
Have you tried the new Numeric Range Filter that was released in the March update?
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-slicer-numeric-range/
You will have to turn it on in your options and I don't think it is live in the service yet (won't be far away)
Thanks for pointing me in the right direction. The update says that it doesn't yet work with Measures, but that functionality is on the way.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-feature-summary/
Hi wmorris20
While it won't work on measures, if you drop a field onto it that covers the number range you want it might work?
eg, what field do you use on the axis of your visual?
That's a good idea. Although it technically works, it doesn't work in a practical sense. In this case, we would need to filter Sales Dollars which is then aggregated to YTD Dollars, which is want we want to display. The problem with filtering Sales Dollars is that one segment might have 1 record of $10 but another segment might have 200,000 records of $10. Filtering it above $10 will significantly limit the use of displaying the YTD.
If we filter at the Measure level, we can achieve removing the noise.
Some other ideas (although again, not ideal) are
- hard code the start/finish axis to fixed values
- use a Log scale to pull back the outliers.