Forum Discussion
Last x days filter and sequential days number
Hi. I made a period slicer for the last 7 days, the last 30 days and few more filters. I used this example to do it and it works well.
However, there is something I don't like and it can generate some confusion. For example:
If current slicer filter is last 7 days and today is 5th of the month. It displays the info for the days 1, 2, 3, 4, 5, 30, 31, in that order.
I wonder if there is a way to display this info like 30, 31, 1, 2, 3, 4, 5
Regards
can you use sort by in your graph by clicking ... on top right corner and pick the field you want to sort it by, in this case it will be date
4 Replies
- Greg_Deckler
Community Champion
You could see if you could set the "Sort By" to a date field.
Maybe I should have included a screenshot. The thing is that I have different layers (Year, month, day). It is displayed like this:
I could remove the these layers and display only the date, but again it isn't sorted:
- parry2k
Super User
can you use sort by in your graph by clicking ... on top right corner and pick the field you want to sort it by, in this case it will be date
v-huizhn-msftMicrosoft Employee
Hi hectormungo,
If current slicer filter is last 7 days and today is 5th of the month. It displays the info for the days 1, 2, 3, 4, 5 in this month, and 30, 31 for last month. You want to oder them ASC, right? If it is, as the Greg_Deckler posted, just click the button highlighted in yellow background ASC shown in the following screenshot.
If you have any other issue, please let me know.
Best Regards,
Angelia
