Forum Discussion
Visual filters on the same table
Trying to do a filter between to visual tables that contains data from the same table.
So, my data table is like following
RowID;CustomerID;EmployeeID;StartDate;EndDate;AwesomeValue;
Now, in my report I have a table where the user selectes a row and a new table where I would like to show rows where StartDate is before the StartDate of the row the user selected.
Data example
1;22;331;08/07/2017 10:17AM;08/07/2017 02:14PM;42;
2;22;333;08/08/2017 09:19AM;08/08/2017 03:17PM;17;
3;99;128;08/07/2017 09:09AM;08/07/2917 09:19:PM;9;
If I in visual table A would select row 2 then row 1 would be visible in table B. Currently what I could get at the moment is that if I select row 2 in table A then that row is visible in table B. I'm leaning towards creating a new data table with the same data but I can't figure out how it would help really. In the long run, both StartDate and EndDate would be filtered to see what entries overlap with the selected entry.
2 Replies
- Phil_SeamarkMicrosoft EmployeeHi there Sounds like you need two disconnected tables and a measure that you can use as a filter for the visual that is using Table B. The measure would return a 1 or 0 based on the comparison between the two start dates and can be used in the visual filter. Does that make sense? I can knock something up for you if you like. Phil
- timnilimaaRegular Visitor
If you could mock something that would be super helpful. Thanks for the reply btw.