Forum Discussion
deechappi
3 years agoFrequent Visitor
Filter the column(s) values based on the slicer
I have a dataset with 4 columns like the one below: Column1 Index Category ID 4908 1 A 123 4912 2 B 456 4915 3 C 789 4918 4 D 134 4922 5 E 178 4925 6 B 398 4928 7 F 549 4932 8 A 753 ...
- Anonymous3 years ago
Hi deechappi ,
Please create an unreleated DimColumn1 table for slicer. Then create a measure to have a test.
Filter = VAR _SELECTVALUE = SELECTEDVALUE ( 'Filter'[Column1] ) VAR _VALUEBEFORE = CALCULATE ( MAX ( 'Table'[Column1] ), FILTER ( ALL ( 'Table' ), 'Table'[Column1] < _SELECTVALUE ) ) RETURN IF ( MAX ( 'Table'[Column1] ) >= _VALUEBEFORE, 1, 0 )Add this filter into table visual and set it to show items when value = 1.
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ray_aramburo
Super User
3 years agoSomething that I can think of is to change the Column1 type to numerical and use it as an slicer and set it up as a "greater than or equal to" type of slicer.
- deechappi3 years agoFrequent Visitor
Thank You ray_aramburo . But, I would also like the one before the selected value as well
- ray_aramburo3 years ago
Super User
You can adjust then to a "Between" type of slicer.
- deechappi3 years agoFrequent Visitor
The requirement is to use the "vertical list" slicer