How to sort a graph by ascending order

[o59393]

Hi all

I need to sort a graph in descending order, the problem I have is that it recognizes for example a 15 before a 2, must be because it starts with 1.

As seen in the red graphs it starts with 10, 11, and so on.

Above is the table I use, how can i correctly sort by ascending order?

Thanks!!

[Tahreem24]

It is happening because your label column is text.

Well, you should create an index column by applying the below steps:
1. go to query editor ans select your Label Column then go to Add column menu and select Index Column. So it will automatically creates index column for starting with 0. Apply and close query editor.
2. Go to Data view tab from left most panel and select Label Column then go to modelling menu then choose Sort by column option and check mark the Index Column.

Don't forget to give thumbs up 👍and accept this as a solution if it helps you.

[o59393]

Hi @Tahreem24  and @TomMartens 

When I create the index column and I select to sort by index in the label column the visuals crash:

How can I fix it ?

Thanks.

[o59393]

I added the index to the visual and went from this:

To this:

I am getting everything with 100% when it should be the count of times as seen in the statement of the problem, how can I correct it?

Thanks!

[o59393]

I attach the pbix, it contains the index column

https://1drv.ms/u/s!ApgeWwGTKtFdhiTj1pBzxG_8LkDW?e=SQDJ4f

In case you want to look and see the problem

Thanks 🙂

[v-lili6-msft · Accepted solution]

HI @o59393 

Just add just the model as below:
Step1:

Use this formula to create Total Sanitary Reg Time Interval column

Total Sanitary Reg Time Interval = calculate(FIRSTNONBLANK(dimIntervals[Label],1),FILTER(dimIntervals,dimIntervals[MinPeriod]<(Ticket[*Department time]+Ticket[Cycle Time (Process)]+Ticket[*Submission to government]) && dimIntervals[MaxPeriod]>=(Ticket[*Department time]+Ticket[Cycle Time (Process)]+Ticket[*Submission to government]) ))

Step2:

Create a relationship between 'Ticket' table and 'dimIntervals' table

Step3:

Now set sort by column and when you create visuals, use [Label] instead of [Total Sanitary Reg Time Interval]

and here is sample pbix file, please try it.

Regards,

Lin

[TomMartens]

Hey @o59393 ,

you have to create an index column and then use this column to sort the column label by this new column.

This article describes how you can sort the label column by another column: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Hopefully this provides what you are looking for.

Regards,

Tom

[MFelix]

Hi @o59393,

Click on the label colum and then on the column options select the sort by and select one of the other two columns since they are numbers it will give you expected result.

Regards,
MFelix

[o59393]

Hi @MFelix 

Kinda lost, yoiu mean here?

thanks.