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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors