CODEWITHSUNDEEP
powerbipowerbi-desktop
Arsee
Arsee

Reputation: 671

PowerBI - x-axis month label sorting

I'm creating a line chart in PowerBi for NPS where the line legend is the year and the x-axi label is the first initial of the month. I'm having a dilemma in sorting the month initial. Can someone assist on this? thanks in advance.

enter image description here

Upvotes: 0

Views: 2476

Answers (1)

user10471965
user10471965

Reputation:

There are two ways to sort.

The first one is on graph level, meaning that you will only sort one specific graph:

Sort on graph

Steps:

  • Click on the graph you want to sort
  • Click on the three dots
  • Click 'sort'(In my example named 'Sorteren op')
  • Choose what you want to sort on.

However, this will most likely not provide you with the right solution. Since it is already sorted on date letter, but in alphabetical order.

Therefore the second solution, sort on colum.

Panes

First, we go to the data tab (Or columns tab). In my example, I have opened a date table to match your question. Here I select the 'MonthShort' (MaandKort) because I want it sorted based on a number instead of on letters.

Sort on column:
Sort on column

Sort on column select:
Sort on column select

If you click the column, it automatically opens the 'kolomhulpmiddelen' tab. Here you can select the 'sort on column' pane and click on the column you want to sort on.

In my case, I chose the monthnumber. So from now on, if I use the MonthShort in a graph, it will sort it based on the monthnumber, meaning that I will see Jan - Feb - Mar etc.

Note: This is from the Dutch version of Power BI.

Upvotes: 0

Related Questions