Forum Discussion
Cond Formatting - web URL blank if cell is blank
I have a table visual with values from 2 datasets, with the option "Show Items With No Data" enabled because I want to see all projects even if they have no status update.
Projects that do not have a status update for the applicable month (from a calendar tables) do not have the web URL conditional formatting applied.
Why?
The URL is coming from the projects table, and the conditional formatting is being applied to the project name which is part of the projects table. A blank status update shouldn't affect it?
Note, the blank values are text fields. I've seen solutions that say "add a +0 to the measure" but the blanks are not measures. They're text field values from the status table.
Sample PBIX - https://drive.google.com/file/d/1MWLeaLGSeYA03x8CAQVj9PZ7KrGhuxSi/view?usp=sharing
See pics below. See projects that have blank "overall" and "status summary" do not have a clickable link applied.
Oh boy. Bad news/good news. Bad news: This is by design. You have selected "Show items with no data" which does a half hearted cross join but that doesn't extend to the conditional formatting as the rows without "Overall" values aren't really there.
Good news - You can create your own cross join between Project and Calendar tables and then add calculated columns that put an empty string where the intersect doesn't return a result.
see attached
4 Replies
- lbendlin
Super User
yes, that should work. Can you post some sample data to recreate the issue scenario?
Apologies. Should have done that.
Here is the pbix.
https://drive.google.com/file/d/1MWLeaLGSeYA03x8CAQVj9PZ7KrGhuxSi/view?usp=sharing
You can see, the projects with no associated status update, do not have the URL underline under the project name.
- lbendlin
Oh boy. Bad news/good news. Bad news: This is by design. You have selected "Show items with no data" which does a half hearted cross join but that doesn't extend to the conditional formatting as the rows without "Overall" values aren't really there.
Good news - You can create your own cross join between Project and Calendar tables and then add calculated columns that put an empty string where the intersect doesn't return a result.
see attached