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.
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.
Solved! Go to Solution.
@Anonymous
In the Format section of the Visualizations pane, expand the X axis card and change the Type option from Continuous to Categorical.
@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>
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |