https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Conditional-Formatting-Based-on-Events-and-Filters/m-p/3828565#M9443 <P>I think you may be looking for CONTAINSSTRING()</P> Wed, 10 Apr 2024 23:40:35 GMT lbendlin 2024-04-10T23:40:35Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Conditional-Formatting-Based-on-Events-and-Filters/m-p/3828288#M9441 <P>I am trying to create a powerbi calendar, using a Matrix. I have been fairly successful to this point. I am now trying to use DAX to create conditional formatting when an event, as seen on the calendar, and the event type slicer match. I am familiar with using a formula to create conditional backgroud colors, so I am stumepd as to why this is not working this time. I have included the screengrab of the DAX formulas, the Calendar and the Layout of the relational tables. Thank you!</P><P>&nbsp;</P><P><img /><img /><img /></P><P>&nbsp;</P> Wed, 10 Apr 2024 19:29:09 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Conditional-Formatting-Based-on-Events-and-Filters/m-p/3828288#M9441 PowerbiJoshB 2024-04-10T19:29:09Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Conditional-Formatting-Based-on-Events-and-Filters/m-p/3828565#M9443 <P>I think you may be looking for CONTAINSSTRING()</P> Wed, 10 Apr 2024 23:40:35 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Conditional-Formatting-Based-on-Events-and-Filters/m-p/3828565#M9443 lbendlin 2024-04-10T23:40:35Z