Forum Discussion
Numeric range dropdown filter
Hi I have an excel dataset as underlying data. It is housing data, so for each row i have a column saying how many rooms the apartment have. See the image below for the column and values. ...
Hi,
Here is one way to do this:
First I created to parameter for slicing the values. Then I created a filter measure:
RoomsFilter =
var _rooms = max(RoomsToFrom[Rooms]) return
IF(and(_rooms<=[RoomsTo Value],_rooms>=[RoomsFrom Value]) ,1,0)
Now I just applied Filter measure to my table:
Now I just applied Filter measure to my table:
By using these steps the behaviour you described can be achieved.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Hi, I did ecatly what you said and tried to apply the measure in my matrix, but it doesnt seem to work, it worked on tables, but i have multiple matrixes like the image below and nothing happens:
Hi,
It is important the filter is "Rooms filter is 1" Now you have "Rooms filter is 1 or 0" This defeats the purpose and it is likely the reason the filter is not working.