how to use a button for a cross-report drillthrough

[JeroenV]

I'm using cross-report drillthrough and it's working fine. (= I activated the right options)

Now I want to use a button to go to the cross-report page; like you can do with "normal" cross-reports.

Is there a possibility to use a button?

[JeroenV · Accepted solution]

the solution is described above (thx to @rajendraongole1 ) 

but the URL has to be a field in the datamodel and not an measure

[JeroenV]

Step 1 (turn on the option), I already did. 

Step 2: I've created the measure (incl the filter I want to use)

But I can't use the measure as an action for the button...

- I activate "action"

- type = web-url

- web-url > click on the function button 

- when I want to select my measure, Power Bi won't accept it!  ???

[rajendraongole1]

Hi @JeroenV - You need to turn this option on in file-option-report settings before you can drill down across reports.

you can turn on this feature in your files>> options and settiongs>> Options >> report settings

Example: 

DrillthroughURL =
VAR BaseURL = "https://app.powerbi.com/groups/{workspace_id}/reports/{report_id}/ReportSection"
VAR DateFilter = "Date/Date eq '" & FORMAT(SELECTEDVALUE('Date'[Date]), "yyyy-MM-dd") & "'"
RETURN BaseURL & "?filter=" & DateFilter

Select the button and in the "Action" section, set the "Web URL" to the measure.

Create the measure as shown above and adjust the base URL and filter logic to fit in your scenario.

It works, check and let know.

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