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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
VenDaFabricator
Frequent Visitor

Chaning Category of a Column to URL in PBI service

I got a semantic model in Power BI Service, which is in DirectLake Storage mode, and with in my dataset got a column 'URL' which hold link to a reference document.  I want to convert this to Category WebURL.  

 

Table:

 

dataset.jpg

Report

report.jpg

 

any clues

1 ACCEPTED SOLUTION
VenDaFabricator
Frequent Visitor

Yes, my table is view in the Lakehouse.

 

I was able to get this done with Visualization => Column => Conditional formatiing 

(Reference: Apply conditional table formatting in Power BI - Power BI | Microsoft Learn)

 

Contional format on a other Other called 'Attachment' with values 'Download' as string

 

conditional formatting.jpg

and assigning URL value to to Attachment column

 

attach.jpg

and now in Report: 

report.jpg

 

Thanks

View solution in original post

3 REPLIES 3
VenDaFabricator
Frequent Visitor

Yes, my table is view in the Lakehouse.

 

I was able to get this done with Visualization => Column => Conditional formatiing 

(Reference: Apply conditional table formatting in Power BI - Power BI | Microsoft Learn)

 

Contional format on a other Other called 'Attachment' with values 'Download' as string

 

conditional formatting.jpg

and assigning URL value to to Attachment column

 

attach.jpg

and now in Report: 

report.jpg

 

Thanks

Hi @VenDaFabricator,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

 

 

Best Regards

Yilong Zhou

 

v-nikhilan-msft
Community Support
Community Support

Hi @VenDaFabricator 
Thanks for using Fabric Community.
You would want to review that in the model that the Data category for the column was properly set for this column in the table. And just a side note, if that table is truly a view and not a table that wouldn't support Direct Lake mode and would simply run in DirectQuery mode.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors