Forum Discussion
Solved
Table Sorting Reset
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. ...
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
I caught those after I sent the message and I am still receiving that same message after correcting.
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