Matrix and bar chart visual showing Data per day but loses order when it is a new month

[JaxonNewbold]

I have a matrix and bar chart visual showing data for a short period of days. When It is a new month combined with days from the last month the order gets messed up. Im trying to show it its true order and havent found any information that has worked for me yet. 

In this visual the 1 is february 1st but the rest of the numbers are from january. How do I get the 1st after the 31st while still showing the data by day and not totals for the month.

[jdbuchanan71 · Accepted solution]

You can add a column to your date table that hold the date (1/1/2023) but is formatted to display the day (dd).  I was not able to get it to work uness formatting it as dd which show the leading 0 (01, 02, etc) but other than that it works.

You can see I am showing only Feb 17th - Mar 1st and it is keeping the March 1 (01) on the end because it is sorting by the actual field value (3/1/2007) but displaying the formatted value: