Changing the X label axis with a text data

[Anonymous]

Hi,

I'm relatively new to Power BI and I've got a custom X axis which I need to sort from Monday to Sunday.

It currently has the days mixed up (Friday till Tuesday).

Previously I've just created a seperate column with 1 to 9 which has labelled each of the corresponding days but I'll be dumping this data daily so I'm hoping for an easier solution.

Can anybody help? Thank you so much!

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

According to your description ,you can follow these steps:

1)change the date format , such  as”(ddd,MMMM d,yyyy)”

2) create two calculated columns :

WEEKDAY = FORMAT('Table'[Date],"DDD")

WEEKDAY-NR = WEEKDAY('Table'[Date],2)

3)sort by column WEEKDAY-NR in Data view

4) create table visual ,put field ‘WEEKDAY’ into Axis and  put field ‘Value’ into Values     

Here is  a sample I  made:

URL: https://wicren-my.sharepoint.com/:u:/g/personal/michael_wicren_onmicrosoft_com/ETBzTumG7cNOjWnvEVqJKeoBAj9V5EjX0Vgsi30GqTRoPA?e=rl4heI

For more details ,you can also refer to this Video tutorials on third-party websites:

Power BI Desktop - Preview Features and Weekday Sorting

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.