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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors