I can't figure out what is going on. I have a column in my model with a url. I've even created the url as a custom column and a measure but expereince the same issue.
The url fields in quesiton have been set to Data Category: Uncategorized
When I open the Web Url Conditional Formatting my windows always opens and the 'Based on field' is red and I'm unable to selected any fields (Columns, custom columns, measures). It also looks like I'm missing the drop down for Summarization. Now I can click the drop down and it will list out all the tables and columns but everything is greyed out.
That said, If i create a new PBIX and choose "Enter Data' and add 2 columns (name, url) and add those to the report I am able to format the web url. So it's not that I can't get this to work but I can't get it to work in my current report.
For what it's worth, it doesn't look like this is just an issue with the Web URL. If I select a column for icons my based on field is also red and I can't select anything. However, I already have fields in the same table that have icons.
Somthing strang is going on. I've rebooted my machine, closed and reopened the file.
Hi all, I realize the original post is over 2 yrs old, but just wanted to let you know I finally solved this today on a whim. The issue has to do with implicit measures not working in your model (like user jpperez mentioned in Aug 2022). The solution is as follows:
Hope that helps! Cheers everyone
If you have enabled calculation groups in your model, this has the side effect of dissabling implicit measures. The URL conditional formating works on the "first" link/web url in your list. So you either have to disable the calculation groups or (I haven't tried this) you could create an explicit measure to do the same job the implicit one used to do.
Has there been any solution to this? This is a very annoying bug. All other reports, newly created or old can format the Web URL just fine for any column but this report can't conditionally format anything. Exactly as described in the original post. I am working on a rather large report and starting over not knowing if or how I will re-introduce this behavior is not really an option.
Also having the same issue.
Funny thing. I tried with an older file where it works and the option is there.
Note it shows the Summarization First.
But when i copy table to a new pbix where i am having the issue, i do not see the summarization and option is greyd out
No Summarization option.
Wonder if something changed recently.
I sort of figured out a solution.
In one case (the working one) the report is using the DirectQuery for PBI Datasets.
In the second one it is a pbix connected to a dataset in the service.
Turning on the DirectQuery for PBI Datasets on the report solved the issue.
I'm having the same issue, it was working perfectly fine some time ago. Columns that have alreayd been formatted still work and take me to the URL, however if I try to edit conditional formatting, it won't let me select the URL field.
Hi @lmf232s ,
You could check the Issues forum here:
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.