Date Table Problem

Question

Hello,&nbsp;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!

cmilligan262 · Answer

BrandonP2121&nbsp;You need to sort months by month number.&nbsp;To do this create a new column Month Number = Month(Date)&nbsp;Click on the month and then sort by Month Number

iamprajot · Answer

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.

brandonp2121 · Answer

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

iamprajot · Answer

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

brandonp2121 · Answer

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?

Forum Discussion

Date Table Problem

10 Replies

Related content

Date Function Problem

Date Slicer not Responsive to Calculated Date Table

Stuck with Date Problem

Logic problem?

Problems with Date filtering