Forum Discussion

timnilimaa's avatar
timnilimaa
Regular Visitor
8 years ago

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_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    Hi 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
    • timnilimaa's avatar
      timnilimaa
      Regular Visitor

      If you could mock something that would be super helpful. Thanks for the reply btw.