Web URL not clickable

[maserr]

Hi there,

I have set a data type on Analysis Services a field which is a Web URL. On Power BI when I use the field, it is set as Web URL but as it is not a measure, I cannot format conditioning this field to a web url.

How could this be possible?

Thanks

[Greg_Deckler]

@maserr If this is a DirectQuery/Live connection to Analysis Services it may not be possible. I assume that you are trying to set the Data Category on the column and it is greyed out?

[maserr]

Dear @Greg_Deckler,

Exactly, I am using Live connection. The data type is set to text, that is greyed up but I also have set on SSAS that is a Web URL on the format field. Should I create a calculated column in order to achieve it?

Thanks

[Greg_Deckler]

@maserr So this is greyed out? If so, create a measure like Measure = MAX('Table'[Web URL Column]) and set that to have a Data Category of Web URL.