Line & Stacked Column Chart Incorrectly Showing Individual Data

[HelloTom]

Hello!

My Objective: I am trying to show three elements together in a line and stacked column chart:
1) Wine Box Receive volume (bar)

2) Wine Box Shipment volume (bar)

3) Lease End Date (dot)

Problem I am Facing: when both warehouse locations are selected the individual Lease Dates don't show correctly (i.e. there seems to be values populating continuously between them rather than each Lease Date being shown individually as one value).  Does anyone have any pro-tips for how to fix this?  

My approach so far: My data model etc are attached in the pictures.  I have tried creating a new column in my DIM_Leases table with a value of "0" to simply show a dot on the x-axis to show lease end dates for each Warehouse.

Any help is appreciated, thank you!

[v-xiaotang · Accepted solution]

Hi @HelloTom 

Change this to zero,

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[HelloTom]

Thank you @v-xiaotang!  Worked very well!

For community sharing purposes, below is the now working version: 
1) Change Stroke Width to "0"
2) 'Turn On' 'Show Marker'