Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I have some data regarding turnover that I am trying to organize by month and quarter. I made a date table that I want to use and put in some random numbers to give me data to populate my graph. However, when I add my date table to the axis it doesn't sort the months in order, and it applies the numbers for all months when I only put data in for Janaury. I have attached the picture below so everyone can see what I mean. Thank you!
Okay, I did that and now it took my numbers out of the month and put them into a "Blank" category. Did I mess up my date table?
Hi @BrandonP2121 ,
If possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is the link to my pbix file: https://drive.google.com/open?id=1SZGt1eQyn5XHCoXMekm0vJBPx8kkwqGx
So I am working with the page titled "turnover 1." I am trying to get numbers to display for Year, Quarter, and Month. I did it correctly once, but I had to change my source files and I keepy getting "Blank" headersin my graph and the headers aren't displaying the data properly.
Hi @BrandonP2121 ,
I can't open your sample in my environment, please make sure the sample is correct and don't lost something, I find that DataMashUp seems to lost in pbix file, I am not sure whether this cause this problem. I suggest you could re-upload your sample.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hmm, I attempted to do that but no change. Do I need to set up relationships between my tables?
Perfect, that solved my first problem, thank you! My next problem is I am trying to figure out why the data I put in for January in my excel file is being populated across all months. I can't seem to figure out where to go from here. Any insights?
@BrandonP2121 You need to sort months by month number.
To do this create a new column Month Number = Month(Date)
Click on the month and then sort by Month Number
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |