Forum Discussion

BenNguyen's avatar
BenNguyen
Frequent Visitor
4 years ago
Solved

Hyperlink multiple slicers to a link

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")

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.

 

DAX
hyperlink
link
Slicer Visualizations
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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.