Continuous XAxis Labeling with Monthly Data

Hello,

  I am working on creating a dashboard that has three types of Granularity... Hourly, Daily, and Monthly... i need the XAXIS labels to change based on the granularity using a TIMESTAMP.

I have experimented with a lot of different options but the best choice i've found is to use just the "TIMESTAMP" for the XAXIS:

This is because if i use the Date Hierarchy, the Year, Month, Day, Hour or whatever i choose will always show regardless of the selection for Granularity... by choosing this option the Format of the XAXIS changes when the granularity changes... which is mostly correct.

However what i am experiencing looks like data mislabeling when using the "Continuous" type XAXIS:

Note that the Column labeled as Feb 2023 is actually January Data... and that the last column is not even labeled which is actually Jun Data...

The only data set i have this problem with is Monthly data... The monthly data is collected 1x per month every month on the last day of the month. 

Categorical does label this correctly, but includes the "hour" part of the timestamp which we do not want to show for the "Monthly" granularity. 

The only way i have found to "change" the format of this label is by changing the Format for the column in the table itself:

This also is not a acceptable solution as this Format change also applies to all granularities and i need it just when the granularity is Monthly. 

Currently i have implemented a solution using String values that i use as the XAXIS Label column... but for strings to sort months correctly i had to introduce the month number like (06)Jun... and this isnt the best solution either:

I've looked for any options to manually control this XAXIS label format from using measures, to Calculated Tables, etc... it seems that continuous labeling for Monthly may not be fully supported, but hope that it is. Any help would be greatly appreciated. Thanks.