Forum Discussion
Date Table Issues
Hello, couple of things to check as the days 1-31 sounds odd.
1. are the dates on the x axis from the date table and not from the fact table?
2. click on the elipses on the visual and check that the order is being done by date and not some other field?
try just bringing in the calendar date field from the date table on to the x axis and PBI will turn it into a Yr/Qtr/Mon/Date for you.
Cheers
1. I originally used the dates on the x axis from the date table
2. I checked and the order is being done by the date
I fixed the 1-31 issue by just using the date from the fact table, so I am using both Dates from Date table and fact table because date from fact table doesn't break down my dates into years, qtr, months. However, the order of the month is still off.
Thank you for trying to help