cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JCBI1023 Member
Member

Why is My Data Not Centered (screenshot included)

Hello Community and Thank you For your help,

 

Take a look at this screenshot:

not center.png

 

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: Why is My Data Not Centered (screenshot included)

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. Smiley Happy

 

Regards

5 REPLIES 5
vanessafvg Super Contributor
Super Contributor

Re: Why is My Data Not Centered (screenshot included)

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?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
JCBI1023 Member
Member

Re: Why is My Data Not Centered (screenshot included)

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

 

 

 sssss.png

 

Ross73312 Super Contributor
Super Contributor

Re: Why is My Data Not Centered (screenshot included)

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


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


JCBI1023 Member
Member

Re: Why is My Data Not Centered (screenshot included)

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

 

Anyway, here are my settings for X and Y.

 

Xaxis.pngyaxis.png

 

 

v-ljerr-msft Super Contributor
Super Contributor

Re: Why is My Data Not Centered (screenshot included)

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. Smiley Happy

 

Regards

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 21 members 762 guests
Please welcome our newest community members: