Filter Table and get values greater than selection

[Anonymous]

Hi, 

I have a table and I need to get values greater than or equal to selection (from same table).

E.g. Lets say we have the following table

Date		Time		id
1/1/2021		10:35:18		1
1/1/2021		12:22:50		2
2/1/2021		09:14:23		3
2/1/2021		13:48:09		4

I need to create a report like

id

1

2 (selected)

3

4

Date		Time
1/1/2021		12:22:50
2/1/2021		09:14:23
2/1/2021		13:48:09

meaning that the second visual is filtered by the first (ids greater than or equal to selected id)

Please mind that this is a simpified scenario and in full scenario I cannot use slicer to filter. I have to filter by table selection

Thank you in advance.

[Anonymous · Accepted solution]

Finally, I did it!

Inspired by this excelent thread Solved: Slicer Value in Column Formula - Microsoft Power BI Community I replaced Slicer by a Table visual, changed the equal condition with >= and set values 0 or 1.

I then filter the latter table by Check measure (1) and voilà!

So, @daxer-almighty  your simple and ULTIMATE answer was not actually quite right 🙂

[daxer-almighty]

Yeah... You did it because you've got 2 different tables and not one. With just one table it's not possible, as I've already said. So, it was a simple and ultimate answer of mine which was right and answered directly the question you asked. Unless you can show me that it's possible with just one table, my answer still holds.

[Anonymous]

@daxer-almighty my question was if that could be done. As I said I don't care if there is a need for creating an additional table.

So, to be fair your answer was a quick and easy escape.

Have a nice day.

[daxer-almighty]

'I have a table and I need to get values greater than or equal to selection (from same table)."

Not really. On top of that - imagine - I did check if that was possible with just one table. So, it was not a quick and easy escape.

[daxer-almighty]

The simple and ultimate answer is that you CAN'T do it if the values come from one and the same table.

[Anonymous]

Dear @daxer-almighty , in this simplistic scenario I can select the id from the first visual so the second visual (same table source) gets filtered thus fetching only values EQUAL to the selected id.

My issue is that I want to get all values greater or equal to the selected id.

This is can't be done DIRECLTLY according to your answer. 

My question was whether this would be feasible through a workaround, mayby a calculated table, lookup table or something like that. I' ve tried several things but with no luck yet.

I'm able to get the desired result by using the Greater or equal SLICER, but the problem is that I have a more complicated scenario where I have to use a Table instead of SLICER.

So the ULTIMATE question is whether we could replace the functionality of such a SLICER (Greater or equal) with a Table visual.

Anyways, thank you for your time.