topic Re: Table Order in DAX Commands and Tips

Table Order

Anonymous — Fri, 09 Aug 2019 20:55:39 GMT

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!

Re: Table Order

Anonymous — Fri, 09 Aug 2019 22:27:40 GMT

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

Re: Table Order

Anonymous — Mon, 12 Aug 2019 12:38:05 GMT

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!

Re: Table Order

Anonymous — Mon, 12 Aug 2019 12:40:11 GMT

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

Re: Table Order

Anonymous — Mon, 12 Aug 2019 15:09:58 GMT

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...) ?

Re: Table Order

Anonymous — Mon, 12 Aug 2019 17:21:43 GMT

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

Best
Darek