Forum Discussion
Changing the X label axis with a text data
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!
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:
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.
1 Reply
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:
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.