Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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
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:
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
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |