Hello,
I understand this might be a bit frustrating, but to achieve the described results, you'll need a normalized dates column. However, there's a way to simplify this process so you don't have to create this column in each table.
You can use the date dimension file provided in this article: Date Dimension File.
Once you import the xlsx file into your data model, you can link it to your existing Fact tables using the date field. This will allow you to create a normalized date column in the dimension table.
On your dashboard, you can then use the normalized date from the dimension table as the X-Axis and use the original date column from the Fact table as a break-by.
I hope this helps! If you have any questions or need further assistance, please feel free to reach out.
https://created-cloud.uk/s/9Hyq8MKniJYm4Jc
