Power BI Desktop Conditional Formatting - Web URL using SSAS Tabular Cube Live Connection

[Anonymous]

Hi,

I am using Power BI Desktop version 2.80.5803.1061 (April 2020) and have a live connection to a SSAS Tabular Cube. I'm trying to use conditional formatting on a Column in a table as a web URL. I have set the URL field to Data Category = 'Uncategorized'.  I am however unable to select the field or any other field for that matter. Are there limitations to conditional formatting web URLs when connected Live? Am I missing a step?

Any help would be greatly appreciated. Thank you!

[v-deddai1-msft]

Hi @Anonymous ,

Based on my test, it works well. Would you please follow the steps in the https://www.youtube.com/watch?v=Wz2aD0XvkUk?

Best Regards,

Dedmon Dai

[Anonymous]

Thanks! I had actually initially tried this method but still couldn't get it to work. See comment below, looks like we're having trouble getting this to work with Live Connection to SSAS.

[Anonymous]

This doesn't work if you connect your Power BI report to a model from SSAS, because you can't calculate first/last etc. I don't know any workaround for this yet.

[Anonymous]

Thanks! I'm still on the lookout as well. I guess for the time being I can change it back to a web URL and use a URL icon.

[v-deddai1-msft]

Hi @Anonymous ，

Would you please tell me if the link in your model is measure or column? When it is column, it works well based on my test.

Best Regards,

Dedmon Dai

[Anonymous]

Column, and it works when you are having a Power BI Data model, not when connecting to a tabular model with direct query