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.
I got this graph:
It shows me all data of 2019,2020 en then for 2021 I see the data for each month.
I want the data in this order in my X-Axis:
2019, 2020, 2021, Jan, Feb, Mar, Apr, May, June, July, Aug,Sept, Oct, Nov, Dec
If I change my month format to 1,2,3 then my graph looks like this:
Can I sort on a column that is not in the visual, or can I add a dummy column to sort on in the graph ?
Solved! Go to Solution.
@elbartje , You need to create a sort order column and mark that sort column
Example
Axis column 1 = [Axis Column]
Axis column sort = Switch(true(),
[Axis Column] = "2019", 1,
[Axis Column] = "2010", 2,
//Add others )
Mark Axis column sort as sort column for Axis column 1 and use Axis column 1 in visual
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Thank you that did the trick !!
@elbartje , You need to create a sort order column and mark that sort column
Example
Axis column 1 = [Axis Column]
Axis column sort = Switch(true(),
[Axis Column] = "2019", 1,
[Axis Column] = "2010", 2,
//Add others )
Mark Axis column sort as sort column for Axis column 1 and use Axis column 1 in visual
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |