Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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.
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
Thanks!
I suspected the conditional formatting wasn't coming across after the first blank was encountered.
This solves it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |