cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jderekc Member
Member

Properly Order Numbers

It would be great if Power BI would properly order numbers.  I'm not sure if this is an idea out there or is being worked on, but here is an example of how it should be:

 

1

2

3

4

5

6

7

8

9

10

11

12

13

 

Instead, I get this:

 

1

10

11

12

13

2

3

4

5

6

7

8

9

 

That's just silly.  It is happening to me in a non-stepped matrix.  I've also noticed this in slicers as well and have to do some "wizadry" to make it work correctly.  Why can't Power BI know that 10 is greater than 1?  I understand that it must look at the first number character and THEN look at the second number character, but this seems like a poor decision.

 

numberexample.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Properly Order Numbers

What data type is that column? Is it actually a number, or is it text?

2 REPLIES 2
Super User
Super User

Re: Properly Order Numbers

What data type is that column? Is it actually a number, or is it text?

jderekc Member
Member

Re: Properly Order Numbers

You've proven me to be an idiot.  It works after switching it to numbers.  I thought it was a number to begin with but no, it was text.  Looks good now, thanks!