cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snoh8r
Helper I
Helper I

X axis header not matching data point

I have the some data that has several points that begin on a Monday and end on a Sunday. I couldn't figure out a new column to create each Monday as a start so I just created a table in Excel to count all the data from Monday to Sunday of each week. As cyou can see, the data point holds the starting day for the week, but the x axis is starting with Sunday. How do I fix that. For the other image, the Months work, but the data points show for the first of each month. I don't want that. Thanks for any help. 

 

Issue.jpg

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@snoh8r 

 

In the Format section of the Visualizations pane, expand the X axis card and change the Type option from Continuous to Categorical.

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@snoh8r 

 

In the Format section of the Visualizations pane, expand the X axis card and change the Type option from Continuous to Categorical.

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Greg_Deckler
Super User
Super User

Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

I'm not clear on what you are going for exactly. 

 

Perhaps take a look at: https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Starting/m-p/391487#M123


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Actually, my end goal just changed. I am attaching

 

 

a workbook. The vendor names have all been changed as were invoice numbers and stuff. In the first sheet, you'll see where I have two tables to calculate some data. Then the charts off to the side of them. Those charts are what I'm trying to recreate. I've got some other visuals to create now as well so they all need to key off the site.  What I was trying to initally do is just create the charts based on the small table. The weeks would start on Monday's. So in the chart image I posted, if you put the cursor over a data point, it reveals the date, but it doesn't correspond with the axis information as it starts on every Sunday. Same with the year. But, now that I need to attach location, I'll have to somehow get the total tickets belonging to each contractor on both sheets, and then put it into that chart.

<iframe width="402" height="346" frameborder="0" scrolling="no" src="https://onedrive.live.com/embed?resid=421CE3342530F1F4%2198093&authkey=%21ABSULYnezgNeb8Y&em=2&wdAllowInteractivity=False&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True&wdInConfigurator=True"></iframe>

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.