Passing filters values from power bi report to report builder

[Peter_23]

Hi community, I'm actually working in report builder, so I have the requeriment to pass select values from power bi report to report builder.

In the report: I have country and city slicer (multivalues with all selected) meanwhile in the report builder I have the same filters; so my user select US and MX (country) and LA and CMDX (cities) the url is something as:

https://app.powerbi.com/groups/me/rdlreports/xxxxxxx-abc7-40f0-b456-febzf9cdda4d?rp:Country=US&rp:Co...

so I have two questions:

1.- Selected multiples values the url is coming too long... so is this possible to pass as  "value,value" ?

https://app.powerbi.com/groups/me/rdlreports/xxxxxxx-abc7-40f0-b456-febzf9cdda4d?rp:Country=US,MX&rp...

2.- When I select all values, is there any way to pass "All" word instead of one by one.

https://app.powerbi.com/groups/me/rdlreports/xxxxxxx-abc7-40f0-b456-febzf9cdda4d?rp:Country=ALL&rp:C...

thanks in advace.

[Peter_23]

thanks @lbendlin  I'll try

[lbendlin · Accepted solution]

1. yes but you would need to split the results on the Report Builder side

2. unfortunately no.  These could be millions of values.  But again - you could parse the URL on the Report Builder side and translate "ALL"  to "no filter".  Make sure you don't accidentally have a data value as "ALL".