Forum Discussion
Filter Table and get values greater than selection
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.
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 🙂
6 Replies
- daxer-almighty
Solution Sage
The simple and ultimate answer is that you CAN'T do it if the values come from one and the same table.
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.
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.
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.
