Forum Discussion

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
2 years ago
Solved

445 calendar matrix visual conditional formatting

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...
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    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.

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
2 years ago

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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

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.