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

[Lucian]

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 topic/subject field based on that URL field, but is not always working.

The issue is 100% reproductible, so I try to explain what I did.

1. Let's assume the following TestTable:

For simplicity of the test, I have also put the M code that will generate it:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTQMzDUMzIwMlHSUQoxMDAEUanFJQru+fnpOakKoUE+QBFDAwMgmVFSUlBspa+fDpbSS87PVYrVwTTCCGaEU2ZeOtQAJN1JQFGEXkNUvcYwvcEFqakpWG0vLy/XKwbJlgDV6eWllugrxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Number = _t, Topic = _t, Amount = _t, URL = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Number", type text}, {"Topic", type text}, {"Amount", Int64.Type}, {"URL", type text}})
in
    #"Changed Type"

2. I have created a simple table visual displaying the fields of the table, just to make sure all of them are visible/ok.

3. I have used "Conditional formatting"/"Web URL" on Topic field and everyting is ok except on rows that don't have an "amount" and I have displayed them using "Show items with no data" on the Date field.

So, the question is possible to have the Topic field formatted with that URL even if no amount?

In the real scenario, that table contains information that should help the viewer to navigate through that URL and check some details related with that item that not always have an "amount".

And because of the usage - the URL column will not be displayed, just used in formatting the Topic column.

Kind Regards,

Lucian

[az38]

Does it work with explicit meaure and without +0?

Maybe you should create an idea to fix it here  https://ideas.fabric.microsoft.com/

[az38 · Accepted solution]

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]

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