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.   Aft...
Need Help
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]), "")

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Super User
    2 years ago

    tonk 
    Can you share the sample pbix file?

    • tonk's avatar
      tonk
      Frequent Visitor
      2 years ago

      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!