Time based chart x axis - linear or continuous?

[Anonymous]

Hi I have a visual that looks like the below, based on sale date (Which is linked to date in a calendar table by a relationship). There is a slicer for people to amend the date range.

This all looks fine, however when narrow date ranges are selected, the x axis starts to look wrong, i.e. 12th November 00:00, 12th November 12:00 etc. I only wish to have one label on the x axis for each day.  

Changing from type 'continuous' to 'categorical' fixes this to a point but means that the visual now doesn't show all dates when they are selected without scrolling across the date range.

Can anyone advise how to sort this please?

Thank you. 

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Stephen Tao

[v-stephen-msft]

Hi @Anonymous ,

If you do not want to modify the date column in your original main table, create a new calendar table. Then create a relationship between the calendar table and your main table.

Please select the Date format for the format of the date column in the calendar table, not the Date\Time format. 

Finally, select the date column of the calendar table as the slicer.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.