Don't know your data structure. However I've assumed your data is like this
I've used reference line to show your Planned value. Drag your fields like this.
While adding reference line you've to drag the planned measure to detail shelf and do the rest as mentioned below.
workbook (version 9.3) attached for your reference. Let me know If this help.
bar chart 9.3.twbx 12.8 KB
Thanks a lot for your quick reply to both.
But the customers want to see the report as I showed you in the screenshot.
Data in the database is like this
Server Status is changing from Planned to Migrated or Canceled in the indicated planned date so I don't know how can I display planned in the past months.
In the screenshot below you can see the current month so you can see 25 planned servers (Blue), 1 canceled (Grey) and 10 Migrated (Green), But I should display one bar with all Planned for this month, that is, 36 (since migrated and canceled were planned for this month) and other bar with Migrated and canceled (Green and grey)
Thanks again for your support
Anyway Luciano, Could you please explain me how you perform that? would be a possible solution thanks
I had built my data like yours but after i simplified.
Using my example, is just replace # Servers by Countd([Server Name]).
I Just calculated Planned and not planned.
I dragged both in rows, status in color for not planned and double axis.
In not planned i decreased size.