Power BI Conditional formatting - not working while using "Show Items with no data"

[tonk]

Hi All,

I applied conditional formatting to several fields and it works fine until I pick up another field from a joined table.

Example:  Conditional formatting to item works fine.

Table

After I join one more table and picking tracking number in report view, some items cannot be highlighted if I selected "Show items with no data".

Table 2

Do you know how to solve this issue so that conditional formatting can also applied to those items without tracking number?

My case is similar to this Solved: Conditional Formatting Bug - Microsoft Fabric Community.

But my field "Tracking number" is text.

[tonk]

I tried to follow your formula  But I got the following message when I moved the measure to the table.

[tharunkumarRTK]

This error is due to per query limits in your desktop. Please remove those limits and try again. And to avoid such error, you can limit the data and optimize your query.

[tonk]

I tried to remove the limits.  However the output shows a few duplicated item A and the new column is empty.  It seems that the following formula cannot be applied to my table.

TrackingNumber = COALESCE(Max('Table'[TrackingNumber]), "")

[tharunkumarRTK]

@tonk 
Can you share the sample pbix file?

[tonk]

Please let me check my data first.  May be this is due to duplicate records that I cannot create one-to-many / many-to-one properly.  Thank you!

[tharunkumarRTK]

@tonk 

you can create measures for text fields as well. for example for youe example you write your meassue like this

TrackingNumber = COALESCE(Max('Table'[TrackingNumber]), "")

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun