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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
PowerbiJoshB
New Contributor

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
Esteemed Contributor III

I think you may be looking for CONTAINSSTRING()

Helpful resources

Announcements
Top Kudoed Authors
Users online (4,584)