Table Sorting Reset

I've created that table and it allows me to sort by the KPI Order column, so it seems as if Power BI has got itself out of sync somehow. You could try saving and then closing / reopening the file, to see if it recalculates, or else delete the table and recreate it. You could use the below TMDL to do that.

createOrReplace

	table Table
		lineageTag: b0c9a34e-38be-459f-b9e8-e7bc30081e75

		column KPI
			dataType: string
			lineageTag: 35618224-93c5-409f-a6e3-a33a2f8715c2
			summarizeBy: none
			sourceColumn: KPI

			annotation SummarizationSetBy = Automatic

		column Category
			dataType: string
			lineageTag: f0a8f8cd-4fc5-4de8-a549-1abbcdef3e4f
			summarizeBy: none
			sourceColumn: Category

			annotation SummarizationSetBy = Automatic

		column 'KPI Name'
			dataType: string
			lineageTag: ba7ddb94-c584-4a67-b36d-42dbec301068
			summarizeBy: none
			sourceColumn: KPI Name
			sortByColumn: 'KPI Order'

			changedProperty = SortByColumn

			annotation SummarizationSetBy = Automatic

		column 'KPI Order'
			dataType: int64
			formatString: 0
			lineageTag: 349ebdd0-de85-4a44-86a9-4ce30fcde481
			summarizeBy: sum
			sourceColumn: KPI Order

			annotation SummarizationSetBy = Automatic

		column 'Category Order'
			dataType: int64
			formatString: 0
			lineageTag: f2bb5e7a-d02f-47d3-b885-bc220a519989
			summarizeBy: sum
			sourceColumn: Category Order

			annotation SummarizationSetBy = Automatic

		partition Table = m
			mode: import
			source =
					let
					    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fZJNa8MwDIb/ism50Dr9Po6MLIMNxhJ2CT2ENnQBLx5OOrZ/P0u2FbtNegix9b6PbMkqy6iQfSVeZHXqoln0IcXlq2aFqlvco8icyvE7zMrotRH1tN+pseeHHCPAe6Hdcysuyf+ofjJ5UeCAv/gbCC0xp63wEDzgLRvxmuiaXJnq7FHXTq24W2yGpHkKSfL0pkAUtnhla7RwYNYbl3RH3rT5rSGSfFbq7HUC48xE9XaP5Xm9IOUatKWQzheEpnkydhJGOScbFjWZ35Q8pI+JS2TXm1bA6obQsbmR+RKfwTG2J5OQ1fkqoGCq7h5ldL4OKOjOPcrqfENU/i17N2Cw7pv27C1p+PgWh8VHqElj3NDBXQAWqjr2UoWUmQYM2AjfE4XXBy1kTFVeIF4Q8qSq9hS+84MQ7LnVC9QYigBxHG2AwNG0/kOOMb4exwY+/AM=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [KPI = _t, Category = _t, #"KPI Name" = _t, #"KPI Order" = _t, #"Category Order" = _t]),
					    #"Changed Type" = Table.TransformColumnTypes(Source,{{"KPI", type text}, {"Category", type text}, {"KPI Name", type text}, {"KPI Order", Int64.Type}, {"Category Order", Int64.Type}})
					in
					    #"Changed Type"

		annotation PBI_ResultType = Table