Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
BrandonP2121
Helper II
Helper II

Date Table Problem

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!power bi 2.JPG

10 REPLIES 10
iamprajot
Responsive Resident
Responsive Resident

For that you need to create a relationship between Datekey[Date] and Vol[Month] otherwise the total of each category will be displayed.

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?power  bi 3.JPG

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.

iamprajot
Responsive Resident
Responsive Resident

Select the visual and go to Sort in too ribbon and you should sort the visual by another column that is a sorted column for e.g. dates.

Hmm, I attempted to do that but no change. Do I need to set up relationships between my tables?

No need of relationships here.
Watch this
https://youtu.be/NlX7Cp2P0d4

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?

cmilligan262
Helper II
Helper II

@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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.