We now have a great Slicer for dates, which is presented as a Slider, but it would be great to have a similar Slider Slicer for values too. eg, If I have a field called 'Customer Balance' and want to give the end user the ability to filter down between two values (Customer Balances between 1000 & 10000), then a standard Slicer is not suitable as it just lists the balances. A Slider based Slicer will fill this role.
26 Comments
- This has been in preview for some time and is now generally available. You can add numeric fields to slicers and select a range of values. We don't yet support measures (you would actually need to specify a measure and a category to slice on) but that's something we're considering - please create a new suggestion for that! One workaround is to create a summary table with the measure/category and slice on that. Thanks for the votes everyone!
akruzelKudo Collector
I totally agree! This kind of slicer would really help with analyzing data because we could easily remove outliers and "zoom in" on certain occurrences in data. I'm thinking it would be neat to incorporate the Time Brush filter in the Power BI gallery. That way you could also visualize the values you're filtering on.- I like the new date slicer. But why restrict this only to dates. It would be great to allow any kind of values to be restricted in that way, instead only date values. Imagine a report with some charts and a Value which has a range of values. But I would like to see the data of a subrange only in the report.
- This is a feature in Qlikview which my client is quite fond of. It would be very handy.
- AhmedIsmail
Advocate II
Totaly agree with this idea,and it needed to any thing logically sorted (A>>Z,Z>>A),(1>>10,10>>1) - I agree as well. How can this not exist? The fact that is has so few votes makes me think I'm missing something. The slicer for Date is close to perfect. It seems like it would be so easy to modify it to accompany a numeric data type. Just like date, it would auto-populate Min/Max and have the slider bar as well as the same filter options (Beween/Before/After).
- Very important for me. My use case: show data from groups that have a share of more than 5% of total.
- The date slider visual is great, but I really need one for numeric values, too. My client wants to see "Sales of items with a price point between X and Y," where X and Y can be adjusted from the dashboard. A slider would be the ideal solution for this.
carvalhoelderThis is a MUST HAVE! feature- We need to consolidate our support behind either one of these Ideas! I wish the moderators would combine these 2 Ideas! https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17267612-slider-slicer-for-values Basic functionality similar to this but for numbers/amounts https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/preview/#dateSlicer
