98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Power BI training and help » Month order on chart
Month order on chart
Resolved · High Priority · Version 365
Faye has attended:
Power BI Modelling, Visualisation and Publishing course
Month order on chart
HI sorry i know this should be really straightforward but I cant figure out the best way to get my data in the correct order. I am assessing a data period of 01/09/2022 - 31/08/2023. When I drag my data into the chart it changes the order so it runs from January to December but i need it to go September - august. Sometimes it does do it from September to august but I cant figure out why. All answers online are different.
RE: Month order on chart
Hi Faye,
Thank you for the forum question.
I assume that you have a date table in the data model.
If you just have data from the period 01/09/2022 - 31/08/2023 your visuals should only show you the period 01/09/2022 - 31/08/2023.
If you have data in the model outside the period you want to display, select the visual and use the filter pane to tell Power BI which period you want to display.
If the visual display January to January even you only have data for the period 01/09/2022 - 31/08/2023 you have an issue with your date format.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 23 Oct 2023: Automatically marked as resolved.
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Create Interactive DashboardsBuild interactive dashboards by leveraging features like slicers, drill-through, and bookmarks. Slicers allow users to filter data dynamically, while drill-through enables detailed exploration of specific data points. Bookmarks help you save the current view, making it easy to switch between different states of your report. |