Filter the column values based on the slicer

[deechappi]

I have a dataset like the below:

Column1 Index
4908 1
4912 2
4915 3
4918 4
4922 5
4925 6
4928 7
4932 8
4935 9
4938 10

There is a slicer for Column1. If a value is selected in the slicer, then the values from one before the selected up to the end should be retrieved.

For example, if I select 4928, then i should get the values
4925 
4928 
4932 
4935 
4938 

[v-cgao-msft · Accepted solution]

Hi @deechappi ,

Consider creating an unconnected table and a measure and using a visual filter.

Please check the attachment.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[deechappi]

Thank You. It worked. But, I would also like to include other columns as well from the table. The filter is not working if I am including other columns in the table.

[CoreyP]

Set your slicer settings to greater than or equal to:

[deechappi]

@CoreyP Thank you. But I also want one value before the selected one.