Forum Discussion
X axis header not matching data point
Anonymous
In the Format section of the Visualizations pane, expand the X axis card and change the Type option from Continuous to Categorical.
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
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>