Forum Discussion
Be
Advocate I
Advocate IHow to create a values range slicer (not a time range)?
I am looking for a way to create a slicer that will put the values into a range. I came across this thread and thought it might be the way to solve this problem - but wanted to create another thread ...
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. :-)
sdjensen
Solution Sage
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.