Line chart x-axis showing day # instead of actual date

[Anonymous]

I have a line chart that is simply couting days and plotting the number of rows by date from left to right. When I show the data by month it looks fine but I want to show it by day (e.g. 2/26, 2/27, 2/28, etc) it just shows numbers

Here is by month...which looks good:

Here is by day, which is not what I want. How do I change this show it shows the actual days?

[v-gizhi-msft · Accepted solution]

Hi,

Please try to create this column:

Column = FORMAT('Table'[Date],"MMMM")&"-"&DAY('Table'[Date])

Then add an index column to this table, After Apply&Close, sort this column by [Index].

Add this column to line chart visual instead of [Date].[Day], the result shows:

 

Hope this helps.

Best Regards,

Giotto Zhi

[dedelman_clng]

Click on the dropdown for Load Date Adj and select "Date" instead of "Date Hierarchy".

You can then format Load Date Adj to show as much or as little of the date as you want. Then change the X axis to Categorical (this may make the chart get really big on the X axis)

Alternatively you can keep Month and Day, and just drill down to the Day level.

Concatenate or do not concatenate labels as desired.

Hope this helps

David

[Hoque]

This is great, Thanks for share your knowledge. 

[rlsmith1994]

This is awesome. So much simpler than writing an unnecessary complicated Dax formula or coding a new column. Thank you!