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><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Relational tables" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1076203iB76806B8953DB717/image-size/large?v=v2&amp;px=999" role="button" title="PowerBI relational table.png" alt="Relational tables" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Relational tables</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Calendar Matrix and filters" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1076202iC3C7DE4A86C8AAF3/image-size/large?v=v2&amp;px=999" role="button" title="PowerBI Calendar error.png" alt="Calendar Matrix and filters" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Calendar Matrix and filters</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DAX error" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1076205i072481213122CE96/image-size/large?v=v2&amp;px=999" role="button" title="PowerBI Measure error.png" alt="DAX error" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">DAX error</span></span></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