Forum Discussion
Date Table Issues
Hi there. I'm very new to powerbi and have watched the tutorials, but I'm stuck. I created a Total Retail column chart with the date on the axis. My data is from Nov 2021 - Feb 2022 and I created a s...
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