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.
Need some help.
I want to sort the days in the chart (from right to left) for last 7 days but the first day of the week will be current day.
In the below screenshot friday is my current day. (this is how i want to sort as shown in the screenshot below).
So , if my current day is "Monday" then the sorting will look like (right to left). (monday to tuesday)
tue wed thu Fri Sat Sun Mon
How can i achieve this please help !!!
Solved! Go to Solution.
Hi @Anonymous ,
and sort the "Week Day" column by Sort_Order column then use the "Week Day" column in the X-Axis.
it will start from today date from right
Please accept it as a solution if it solves your problem. Thanks!
Hi @Anonymous ,
and sort the "Week Day" column by Sort_Order column then use the "Week Day" column in the X-Axis.
it will start from today date from right
Please accept it as a solution if it solves your problem. Thanks!
Hi @Anonymous ,
You can achieve it as below,
@Anonymous
Hi
Do you have a calendar table?
If yes add a new column with first three letter of the day. Ex. Sun Mon.
Then filter date to top 7 days in the visual filters. Then order by descending.
Thank you.
I have tried this before but it is not working.
@Anonymous ,
1 Add a new table with latest 7 days of calender.
2 Add Day column
3 Sort Day column by Date column
4 Create relationship between calander table date column and new table date column.
5 Use new table Day column to visual.
Thank you
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |