Forum Discussion

Lucian's avatar
Lucian
Responsive Resident
2 years ago
Solved

Bug or else?: Conditional formatting as URL isn't working for some rows (show items with no data)

Hello,   I have an issue using conditional formatting using "Web URL" option. I have a table with some information, and one of the field is an URL to that specific item. What I need is to format a ...
Need Help
  • az38's avatar
    az38
    2 years ago

    Hi Lucian 

    Interesting.

    What if to add +0 to your measure (or create it, if you use implicit one):

    Sum of Amount = SUM(Table[Amount]) + 0

     

josef78's avatar
josef78
Memorable Member
9 months ago

It is Bug
In Power BI Table visuals, Web URL conditional formatting fails to apply on rows that are displayed solely due to the "Show items with no data" option. If any measure is used (implicit or explicit) and all measures on a row are blank, the row is rendered, but the URL formatting is ignored—as if the row didn’t exist. This happens regardless of whether the URL is a column or a measure.

 

Workaround:
The issue can be bypassed by either adding any measure that always returns a non-blank value (e.g., a total count, first non-blank URL, etc.), or by creating a dummy measure like HideMe = "" and hiding it visually (e.g., setting column width to zero). This forces Power BI to treat the row as valid for formatting. However, this is still just a workaround and not a proper solution.