Forum Discussion

Lucian's avatar
Lucian
Icon for Responsive Resident rankResponsive 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

     

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
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

 

  • Lucian's avatar
    Lucian
    Icon for Responsive Resident rankResponsive Resident
    2 years ago

    Hi az38 ,

     

    And thank you for your quick response.

    Indeed, creating a measure and adding that "+0" at the end will do the expected formatting 🤔.

    Even I don't understand why Microsoft decided to ignore the formatting from the beginning... but I think I have to use your workaround. 😁

    So thank  you very much.

     

    Kind Regards,

    Lucian