Different Color Cluster Column Chart - Same Dataset

[JessSvetlik]

HI!  I am looking to use a cluster column chart and be able to fill different columns based on the same value set.  My measure is actual plus forecast in a cluster column chart, and I am needing future months to show as a different filling.  Any help with be appreciated! 

Thank you!

[olgad]

@JessSvetlik Have my answer or you yourself solved your problem? If so, can you please share your solution or accept my answer as Solution to help other members find it faster? Thank you very much for your kind cooperation!

[olgad]

Hi, 

on calendar table first create column

Today = Today()

then another column

BeforeNextMonth= if('Calendar'[Date]>ENDOFMONTH('Calendar'[Today]), 0,  if('Calendar'[Date]<=ENDOFMONTH('Calendar'[Today]),1))

0 will stand for your future months, 1 for actuals

then go to format settings-column-color, assign different colors based on rules