The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
Hope you don't mind this post and hopefully someone can help me with some trouble I have been having. I have a graph that shows the last 12 months and shows it as January to December and is not taking the year into account.
Please see screenshot of visual below.
The January - April relates to 2022, and May onwards relates to 2021. Is there anyway I can have it so it runs as May 2021 to April 2022?
Thanks in advance!
Solved! Go to Solution.
You need to add a Sort By column to get your desired order.
Sort one column by another column in Power BI - Power BI | Microsoft Docs
FYI that there a date tables out there you could use that already have a YearMonth column you could use too. Here is an example.
No Sort Date Tables! – Hoosier BI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi,
You should change the format of Date column as per below:
& then
Thank you for taking the time to respond and demonstrate, that's really helpful and can see that would've worked too. I have already adopted Pat's approach below and that worked for me too. Thanks again.
You need to add a Sort By column to get your desired order.
Sort one column by another column in Power BI - Power BI | Microsoft Docs
FYI that there a date tables out there you could use that already have a YearMonth column you could use too. Here is an example.
No Sort Date Tables! – Hoosier BI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks Pat, this helped and achieved exactly what I wanted it too!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |