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)
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.