Forum Discussion

tonk's avatar
tonk
Frequent Visitor
2 years ago

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

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.

Need Help

6 Replies

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Super User
    2 years ago

    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

     

  • tonk's avatar
    tonk
    Frequent Visitor
    2 years ago

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

     

    • tharunkumarRTK's avatar
      tharunkumarRTK
      Super User
      2 years ago

      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's avatar
        tonk
        Frequent Visitor
        2 years ago

        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]), "")