Conditional Formatting by URL

[Anonymous]

Hi Guys,

I'm trying to do conditional formatting by URL for one of my column in my report.

I've different URLs for all different Source types like 

For Supplier : https://abc.energy/broker/deal/detail

For Consulting : https://abc.energy/broker/Consulting/detail

How can I do the formatting for each Source Type? I tried creating a custom column and using URL and & function but it is returning same URL for each source type and I want seperate URLs.

I have already created a URL for Customer and that is fine but for Deal I need seperate URL as stated above.

Is there any possibility for this?

P.S : I have unique ID for each row in the table.

Regards,

Himanshu

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Anonymous ,

Not very clear...

Could you please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business?

Here is my pbix file.

Best Regards,
Eyelyn Qin