Forum Discussion
Web URL not clickable
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 t...
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?
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
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.