Forum Discussion
Adjust date display on line graph
I have dates listed for time values across 4-day weeks (Monday-Thursday) however plotting these along the x-asis has large spaces of straight line in between the listed values. Is there anyway to skip these spaces and only display the days with values on them on the x-axis?
hi bstockwell ,
you can create a weekday table consisting only two columns like:
1 Monday2 Tuesday
3 Wednesday
4 Thursday
or you add a calculated column with the weekdaynumbers.
then plot the x-axis with weekdaynumber column.
Hi, bstockwell
Thanks FreemanZ , I have the following additions. You can follow the image below to display dates with only values:
Turn off show items with no data:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
FreemanZSuper User
hi bstockwell ,
you can create a weekday table consisting only two columns like:
1 Monday2 Tuesday
3 Wednesday
4 Thursday
or you add a calculated column with the weekdaynumbers.
then plot the x-axis with weekdaynumber column.
Hi, bstockwell
Thanks FreemanZ , I have the following additions. You can follow the image below to display dates with only values:
Turn off show items with no data:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.