Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
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!
Relational tables
Calendar Matrix and filters
DAX error
I think you may be looking for CONTAINSSTRING()
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.