Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am creating a trendline in PowerBI by using a date hierarcy on year, quarter, month. When selecting the month and having a filter on for instance 1-4-2019 to 31-3-2020, I would expect that the months are presented in this way (e.g. month most to the left is April, followed by May etc. ending on the right with March 2020). However, the graphs shows the calender year ordering (starting January ending with December). This makes it difficult to interpret the numbers correctly.
How do I change these settings?
FYI, the dataset is build on a live connection so I cannot adjust ordering with columns..
Solved! Go to Solution.
Hi @Anonymous
If you click on "expand all level" below, it would sort as expected by the order "year-month".
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
If you click on "expand all level" below, it would sort as expected by the order "year-month".
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
Check the sort column for month in this file -https://www.dropbox.com/s/wrcyk5j66corvjg/Apr2Mar-Cal.pbix?dl=0
This calendar for, FY Apr-Mar
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
63 | |
53 | |
39 | |
25 |
User | Count |
---|---|
85 | |
57 | |
45 | |
43 | |
38 |