Date Table Problem

[BrandonP2121]

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!

[iamprajot]

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

[BrandonP2121]

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?

[dax]

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.

[BrandonP2121]

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.

[dax]

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]

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]

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

[iamprajot]

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

[BrandonP2121]

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]

@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