Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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?
Proud to be a Super User!
@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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |