Table Sorting Reset

[cheid]

I am getting the below message no matter what column I sort when using "Sort By Column" in the Table View. Is there anyway to reset these sorts so I can sort by the correct column?  Thanks.

[johnt75]

The issue is that you have multiple entries in the KPI Name column with the same values - there are 2 Totals and 2 Fixed Charges. If you change the duplicate values so that they have distinct names then you will be able to sort by the KPI order column.

[cheid]

I caught those after I sent the message and I am still receiving that same message after correcting. 

[danextian]

I've experienced that several times. Power BI says there are duplicates when there aren't. You can use Tabular Editor to enforce the sorting or disable the load of the query then load it again.

[ryan_mayu]

@cheid 

is this part of your data or the whole data of the table?

you can go to powerquery , keep duplicated to see if we have the same KPI name or not.

if this issue still can't be solved, pls share the pbix file.

[johnt75 · Accepted solution]

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