Hyperlink multiple slicers to a link

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.