The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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()