Sort Data on Graph by last 7 days. Day & Month shown

[Anonymous]

Hi,

I'm trying to show the last 7 days of sales. The time period is at the beginning of the month and I want the day to be all the way on the right and the ending of the previous month to be on the left. I've been thinking of setting up a category of months with the days in them but I don't know how to do it.

Please help,
Charlie

[dax]

Hi cohughe23, 

I don't understand your requirement, if possible, could you please explain this ofr me in details(he time period is at the beginning of the month and I want the day to be all the way on the right and the ending of the previous month to be on the left. I've been thinking of setting up a category of months with the days in them)? If possible, could you please inform me your sample data and expecting output? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

[Anonymous]

Hi,

I've attached the images. As you can see it is in order by month and if I drill down in the month it will be organised by day but it will miss the days of the other month.

The second image is both the days combined but the 2nd of September is on the left and it looks as if it has occured before August. I don't know what the best resolution is. Let me know if you would like to see the table but it has date formatting in the column.

Zoe any help will be greatly appreciated.

Best,
Charlie

[dax · Accepted solution]

Hi cohughe23,

You could try to click this button instead of "go to next level", it will show result like below

Or you could create calculated columns like below 

year = sort[date].[Year]
monthno = sort[date].[MonthNo] 
monthname = sort[date].[Month]
day = sort[date].[Year]& sort[date].[Month]&sort[date].[Day]

Then set day sort by date and monthname sort by monthno, then design chart like below and when you click on "get to next level", it wil show like below

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.