Why is My Data Not Centered (screenshot included)

[JCBI1023]

Hello Community and Thank you For your help,

Take a look at this screenshot:

Why are my vertical bar charts not centered on the x-axis dates? Please let me know if you need more information. 

[v-ljerr-msft · Accepted solution]

Hi @JCBI1023,

I noticed that you're using different measures for monthly wholegoodes as columns in the Chart(Normally, we just need a single measure to calculate the wholegoodes, then show it with a date column to get monthly wholegoodes). So I think this may cause this issue in this case.

Could you post your table structures(including the measures you're using) with some sample data, so that we can help further investigate on this issue? It's better to share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

Regards

[vanessafvg]

Please define what you mean by centred - its probably been a long day but the problem isnt obvious to me?  But I'm guess any issues might arise from the size of your labels, if you set your data labels to auto what happens?

[JCBI1023]

@vanessafvg Thanks for the reply. See my X Axis Vertical Line for Wholegoods? I want that centered just like the red sales line is, so they are properly converging. Febuary looks good but the other months are off.

 

[Anonymous]

Can you please post a screenshot of your settings, particularly under X-Axis and Y-Axis?

I'm wondering if you might have the "Type" setting different for Columns compared to Lines

[JCBI1023]

Hello @Anonymous, I do not see a "Type" setting. Are you referring to Data Type within Modeling?

Anyway, here are my settings for X and Y.