Hyperlink multiple slicers to a link

[BenNguyen]

Dear Team,

 I have a test link
https://powerbi.com/reports/powerbi/Production/testData_abcd

and a slicer called "Region" with data: DE, IN, US,...

Requirement: if users select a Region option then that value will be added as a tail in the link above.

I already found a way with IF formulas:

a) RegionSelected = IF(ISFILTERED(Sheet1[Region]),SELECTEDVALUE(Sheet1[Region]),"Select all")

b) Formula1= IF([RegionSelected]="Select all","https://powerbi.com/reports/powerbi/Production/testData_abcd","https://powerbi.com/reports/powerbi/Production/testData_abcd?filter=Sheet1/Region eq '"&[RegionSelected]&"'")

it meets the request, BUT if we have multiple slicers then I have to create another IF for each slicer and combine all of them in the DAX. It look too lengthy and unprofessional...

For example: I have one more slicer called "Component". Another IF have been created as following:

c) ComponentSelected = IF(ISFILTERED(Sheet1[Component]),SELECTEDVALUE(Sheet1[Component]),"Select all")
d)

Formula2 = IF([Formula1]="https://powerbi.com/reports/powerbi/Production/testData_abcd", IF([ComponentSelected]="Select all", [Formula1],[Formula1]&" and Sheet1/Component eq '"&[ComponentSelected]&"'")

Question:
Do we have another way to sync slicer with a link?
Or another concise formula that can solve this problem?
Could you please check and support? Thank you.

[v-yanjiang-msft · Accepted solution]

Hi @BenNguyen ,

According to your description, here's my solution, measures need to be built for each slicer, but the final link only needs one formula.

RegionSelected =
IF (
    ISFILTERED ( Sheet1[Region] ),
    "?filter=Sheet1/Region eq '" & SELECTEDVALUE ( Sheet1[Region] ) & "'",
    BLANK ()
)

ComponentSelected =
IF (
    ISFILTERED ( Sheet1[Component] ) && ISFILTERED ( Sheet1[Region] ),
    " and Sheet1/Component eq '" & SELECTEDVALUE ( Sheet1[Component] ) & "'",
    IF (
        ISFILTERED ( Sheet1[Component] ),
        "?filter=Sheet1/Component eq '" & SELECTEDVALUE ( Sheet1[Component] ) & "'",
        BLANK ()
    )
)

Link =
"https://powerbi.com/reports/powerbi/Production/testData_abcd" & [RegionSelected] & [ComponentSelected]

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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

[BenNguyen]

Thank you so much @v-yanjiang-msft . That looks really better now.