Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have the below sample data. When I created column chart with weekday on X-axis & Value on Y-axis. I am not able to order the weekday with actual day of the week order i.e monday, tuesday, wednesday....Holiday. I tried creating new column with switch DAX but its not working. I am getting below result on PBI. Can you please help to sort?
WeekDay | Value |
Monday | 5 |
Friday | 4 |
Saturday | 3 |
Tuesday | 6 |
Wednesday | 1 |
Thursday | 8 |
Sunday | 9 |
Holiday | 2 |
Thanks
Solved! Go to Solution.
@susheel1347 , if you have date in table create a sort column
Weekday = weekday([date])
Weekday1 = weekday
weekday sort = Switch( True(),
[Weekday]= "Monday" ,1 ,
//Add others
8//default value
)
And sort weekday 1 on weekday sort
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
else create
@susheel1347 , Then refer to my second option
Weekday1 = weekday
weekday sort = Switch( True(),
[Weekday]= "Monday" ,1 ,
//Add others
8//default value
)
And sort weekday 1 on weekday sort https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
@susheel1347 , Then refer to my second option
Weekday1 = weekday
weekday sort = Switch( True(),
[Weekday]= "Monday" ,1 ,
//Add others
8//default value
)
And sort weekday 1 on weekday sort https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
@susheel1347 , if you have date in table create a sort column
Weekday = weekday([date])
Weekday1 = weekday
weekday sort = Switch( True(),
[Weekday]= "Monday" ,1 ,
//Add others
8//default value
)
And sort weekday 1 on weekday sort
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
else create
@amitchandak - I do not have a date column. I only have 2 columns weekday & value.
You need to sort the WeekDay column using Value column. There is a option to do so in Data View.
After that, sort your chart on Weekday.(Check descending/ascending as per your requirement)
Please mark this as a solution if it help you solve your issue.
Regards,
Veena Shenolikar
Hi @susheel1347 ,
You need to change the sorting of the chart from Values to Weekday column. Have you tried this?
Mark this as a solution if it helped solve your issue.
Veena Shenolikar
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |