HELP........How to sort values high to low, not in numerical order?

[Sharon5138]

HI

Please can you help me, I have a large amount of data and the table created sorts in numerical order however I need the highest to lowest and in addition top 5 or 10.

As you can see my screenshot is in numerical order, I would like the high to low for March and the Top 5 or 10 in March

Any help I would be very grateful.

Thanks in advance.

Regards

Sharon

[Jihwan_Kim]

Hi,

I am not sure how your semantic model looks like, but please try to change the column's data type to whole number.
I think the column's data type now is, text type.

Please check the below picture and the attached pbix file.

[Sharon5138]

Hi Jihwan

Thank you for your quick response.

I have now been able to get it in to amount order, so thank you for that, but if I select Top 5 it only displays more than 4?

Regards

Sharon

[Jihwan_Kim · Accepted solution]

Hi,

Thank you for your message, and I think, Amount paid in the filter pane is not aggregated.

If you can check my sample, the auto-aggregated amount paid (Sum of amount paid) is in the filter pane for defining TOP N.

If you do not want auto-aggregation, please try creating a measure, and then you can put the measure into the filter pane for defining TOP N.

I hope this helps.

Thank you.

[Sharon5138]

Thank for your help.