Forum Discussion

HelloTom's avatar
HelloTom
Microsoft Employee
4 years ago
Solved

Line & Stacked Column Chart Incorrectly Showing Individual Data

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!

  • 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.

2 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support

    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's avatar
      HelloTom
      Microsoft Employee

      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'