Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sort by is not working

I have a matrix and I want the Row item (called Product) to be sorted in a specific order so I created a column in Query Editor called 'Order' and i've used an IF statement to define the order as 01,...
Need Help
makcim392's avatar
makcim392
Advocate I
6 years ago

Hi,

 

I came across the same issue. I went to edit query, I have a simple column called code_person. Selected said column as 'whole number'.

 

 

 

It works fine when I sort them in power query. When I go back to the Data View, they are showing up like this:

 

 

 

any ideas why?

 

thanks!

 

  • makcim392's avatar
    makcim392
    Advocate I
    6 years ago

    ok, so I just discovered that you have to change the Data Type to whole number, in order for it to get ordered as a number. 

     

     

    So I wonder, what's the point in selecting the type of data in editing query, if I have to do it again in Data View?