Table Order

[Anonymous]

Hello, 

I need help with table order, thats what I get when i put the camp on filter:

But that the correct order:

How can i make the filter be on the correct order?

Tks!

[Anonymous · Accepted solution]

You have to have a column (an integer would be best) that the names map to. And then there's an option in PBI to set the order of the names to the integer column.

Best
Darek

[Anonymous]

Hi,

I created a column with the correct order number, and after that, I order the column by that new column, and the order change, but isn't the correct yet, any idea why?

New column "Ordem":

New order:

Tks!

[Anonymous]

It's not enough to just create the order column. You have to sort the column in question by it. Google: sort column by another in PBI.

Best
Darek

[Anonymous]

I did that, but for some reason, my PBI were reading in that order: 1, 10, 11, 12, 13, 14, 2.

Always the "1" first, i don't know why,

so, i started my sequence with 10 until 23 and work!!!

Tks for helping! Do you have any idea how to make my PBI reading in the right order (1, 2, 3...) ?

[Anonymous]

That's because you did not change the data type of the column. It had to be INTEGER, not text.

Best
Darek