445 calendar matrix visual conditional formatting

[DataNinja777]

Hi Power BI experts,

I am trying to create a 445 calendar visual (handmade) using matrix visual, as I couldn't find custom visual for non-standard calendar visual.  I'd like to highlight the last Sunday of the 445 calendar using the conditional formatting with red color.

I have a measure of last day of the month in the 445 calendar table, and I'd like to use the red color as a background color for the last Sunday in the 445 calendar month.  Please could you let me know how I can do this?  In the interface below, I don't seem to be able to write the condition of the rule if the value is equal to the output of the last day of the month measure, highlight in red.  

Thank you for your help!

[DataNinja777]

Thanks @Greg_Deckler  I created a calculated column indicating if a particular date is equal to month end date and then if it is "Yes" in that field, color that in matrix using conditional formatting.  

[Greg_Deckler]

@DataNinja777 Just write your measure so that it returns the red color (#FF0000 or whatever) for the last Sunday of the 445 calendar month and then use, I think field value, instead of rules. Have it return BLANK for any other date.

[DataNinja777]

Thanks @Greg_Deckler 

I'd like to also write the measure to concatenate the tasks to be performed on the particular calendar date, and I'd greatly appreciate it if you could let me know how I can assign the color to the measure output.  

Thanks a lot for your help!

[Greg_Deckler · Accepted solution]

@DataNinja777 To change the color using measure output, all you have to do is return the color code like "#FF0000" as a string value. You then set your conditional formatting to Field value instead of Rules and choose your measure.