Skip to main content

Power BI

Completed

Slider / Slicer for Values

Vote (216) Share
David Aldred's profile image

David Aldred on 29 Nov 2016 07:28:24

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.

Administrator on 10 May 2018 00:14:36

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!

Comments (24)
David Aldred's profile image Profile Picture

Power BI User on 05 Jul 2020 22:52:30

RE: Slider / Slicer for Values

Any update on when this feature can be available

David Aldred's profile image Profile Picture

sandeep movva on 05 Jul 2020 22:43:14

RE: Slider / Slicer for Values

Agree, This can be used for what if analysis also by selecting a range, I have implemented this in Qlikview, good feature to have

David Aldred's profile image Profile Picture

Frank on 05 Jul 2020 22:43:03

RE: Slider / Slicer for Values

I love the improvement to slicers where numeric values now have a range selector.
However this new feature does not yet exist when I publish my report.
Am I missing something or is it due to this feature being in preview status?

David Aldred's profile image Profile Picture

Sean on 05 Jul 2020 22:41:52

RE: Slider / Slicer for Values

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/17620606-numeric-slider
Basic functionality similar to this but for numbers/amounts
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/preview/#dateSlicer

David Aldred's profile image Profile Picture

Sean on 05 Jul 2020 22:41:48

RE: Slider / Slicer for Values

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

David Aldred's profile image Profile Picture

Power BI User on 05 Jul 2020 22:41:30

RE: Slider / Slicer for Values

This is highly needed and seems simple.

David Aldred's profile image Profile Picture

Elder Carvalho on 05 Jul 2020 22:39:27

RE: Slider / Slicer for Values

This is a MUST HAVE! feature

David Aldred's profile image Profile Picture

Michal Prussak on 05 Jul 2020 22:37:23

RE: Slider / Slicer for Values

Very important for me. My use case: show data from groups that have a share of more than 5% of total.

David Aldred's profile image Profile Picture

Power BI User on 05 Jul 2020 22:37:18

RE: Slider / Slicer for Values

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.

David Aldred's profile image Profile Picture

Power BI User on 05 Jul 2020 22:36:24

RE: Slider / Slicer for Values

This is a feature in Qlikview which my client is quite fond of. It would be very handy.