Need your help with my Stacked Column chart

[theunissenp]

Hello Guys,

I need your help with my stacked column. As you can see on the image i have columns for two categories red is planning and green is actuals. My problem is the following, the visual is showing al planning months followed by all actual months. It should show for example in February stacked column for my Actuals and one for my forecast. 

Date and category key are used as dimensions on the shared axes. 

Many thanks for your reply.

[gooranga1]

Hi @theunissenp 

Don't use your category on the axis move it to the Legend area insterad.

[theunissenp]

When i use the legend i can't add more than one keyfigure in the value field. But i fix one problem en created a new one. As you can see below my stacked columns are correct now. Last problem is my lines, first three months it only shows dots.  Any idea how i can fix this?  

Many thanks!