Forum Discussion
Advocate IHow to create a values range slicer (not a time range)?
Thinking about it now... there's a much simpler solution.
Just edit your query (Get Data) and add a custom column with this formula:Text.From(Number.RoundDown([actual odometer values]/5000,0)*5000/1000) & "K - " & Text.From(((Number.RoundDown([actual odometer values]/5000,0)*5000+5000)/1000)) & "K"
That will give you a table like this and you can simply filter on the new column
You can use the first approach I posted here if the ranges would not always contain 5000 but vary in steps... But otherwise i'D go for this second option. :-)
Hi,
The solution discussed in this thread is great however it does not enable users to select any range they would like, for example they would not be able to select 2500-7500 km. As an alternative I was wondering if a generic slicer that would apply a filter on decimal values was available ? I'm thinking about something similar to the "Time Brush" or "Advanced Time Slicer" visuals, but that would support any decimal values instead of only Date/Time values.
Any recommendations ?
Solution SageYou could perhaps use the "Conditional Column" feature to create your ranges and a sorting column.
That is exactly what I'm currently doing. This works for creating a pre defined range as shown in the previous messages from this thread but it does not enable the user to select his own range.