Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
PCorbitt
Helper I
Helper I

URL Link Issues

Using the following simple measures, I have successfully created working web links on my dashboard. It leads the users to specific landing pages for one type of product or another based on a selected value, but the links are behaving oddly. They are underlined, but not blue, as would be typical, nor am I able to convert them into link icons. 

 

(The two separate measures (one for each type of store) are similar and they look like this): 

BikeURLPass =
var rptfilter = "Directory/StoreType eq "&"'"&SELECTEDVALUE(Directory[StoreType])&"'"
return
rpturl&rptfilter
 
Each of these measures returns a link to the right page, with the right filter. The problem seems to have started after passing it through the last measure which is necessary in order to automatically display the right link for the right store type.
 
URLSelection =
IF (SELECTEDVALUE(Directory[Store]) = BLANK(), [BikeURLPass], [FlowerURLPass]

 

PCorbitt_0-1687891160109.png

 

Any idea what's wrong?

1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

Hi @PCorbitt ,

According to your description, here's my solution. Modify the BikeURLPass measure to:

BikeURLPass =
VAR rpturl = "https://app.powerbi.com/groups/me/reports/8590193a-cfd0-4f12-8dfb-d7cca9a91aa1/ReportSection18b2e86904674a27b4a1?experience=power-bi"
VAR rptfilter =
    IF (
        ISFILTERED ( Directory[StoreType] ),
        "&filter=Directory/StoreType eq " & "'"
            & SELECTEDVALUE ( Directory[StoreType] ) & "'"
    )
RETURN
    rpturl & rptfilter

Also modify the [FlowerURLPass] measure in this way. By my test, it get correct result.

 

Best regards,

Community Support Team_yanjiang

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

View solution in original post

2 REPLIES 2
PCorbitt
Helper I
Helper I

Thank you so much for your help, but it turned out to be a amateur mistake on my part, solved by simply recategorizing a couple fields! Good to go now but I'm sure I'll have more questions. This forum has been a lifesaver!

v-yanjiang-msft
Community Support
Community Support

Hi @PCorbitt ,

According to your description, here's my solution. Modify the BikeURLPass measure to:

BikeURLPass =
VAR rpturl = "https://app.powerbi.com/groups/me/reports/8590193a-cfd0-4f12-8dfb-d7cca9a91aa1/ReportSection18b2e86904674a27b4a1?experience=power-bi"
VAR rptfilter =
    IF (
        ISFILTERED ( Directory[StoreType] ),
        "&filter=Directory/StoreType eq " & "'"
            & SELECTEDVALUE ( Directory[StoreType] ) & "'"
    )
RETURN
    rpturl & rptfilter

Also modify the [FlowerURLPass] measure in this way. By my test, it get correct result.

 

Best regards,

Community Support Team_yanjiang

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

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.