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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors