Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
PowerbiJoshB
New Member

Conditional Formatting Based on Events and Filters

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 tablesRelational tablesCalendar Matrix and filtersCalendar Matrix and filtersDAX errorDAX error

 

1 REPLY 1
lbendlin
Super User
Super User

I think you may be looking for CONTAINSSTRING()

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors