cross report drill through passing order date greater than instead of equal

[Anonymous]

Hi,

I have a cross report drill through from source report A to target report B.  Lets say I have Order Number 1234 and Order Date of 1/1/2024 on source report A, I then do cross report drill to report B.  Instead of passing Order Number = 1234 and Order Date = 1/1/2024, for Order Date, can I have it pass as Order Date > 1/1/2024 instead of =?  

Thanks!

[Anonymous]

Hi @v-zhengdxu-msft,

Thanks for your reply.  was going to try out your solution but noticed that you are using 3rd party slicer, as a company, we are not allowed to use 3rd party slicers.  

Thanks!

[v-zhengdxu-msft]

Hi @Anonymous 

Unfortunately that the Drill through can only filter the target report page with "is" but not "After" or "Before".

Here is an alternative workaround:

I have a set of sample data:

Then add a new table:

Table 2 = VALUES('Table'[Date])

Create a slicer with 'table'[Date] in page 1:

Click the Sync slicers in the view pane:

In Advanced options's box, Type the Date:

And a slicer with 'Table 2'[Date] in page 2 and type the same Date too.

Next, search for the Preselected Slicer in the Get more visuals:

Enter data:

And create a measure:

MEASURE =
VAR _slicer =
    MAX ( 'Table 2'[Date] )
RETURN
    IF ( MAX ( 'Table'[Date] ) > _slicer, TRUE (), FALSE () )

Add the preselected slicer to the report:

The result is as follow:

When click the 2024-1-1 in page 1:

In page 2, the Preselected slicer can select the date that are after 2024-1-1.

You can use the  button to hide the slicer in the page 2:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.