Unable to Sort by Columns

[Gururajv007]

Dear Experts - I am unable to sort the "Stage for Final report" ( TEXT FORMAT ) Column as per the Index in"Stage Final Index" ( Whole number format ) 

Error getting : Sory by Another Column - This column can't be sorted by a column that is already sorted, directly or indirectly, by this column.  Any suggestion, please.

[V-lianl-msft · Accepted solution]

Hi @@Gururajv007 ,

Based on your description,if the value of "Stage Final Index" depends on "Stage for Final report", you cannot sort "Stage for Final report" by "Stage Final Index".

You can also refer to following blog to know how to create a related sort table to enable sort by column feature: http://www.excelnaccess.com/custom-sorting-in-power-bi/

(Note: This link contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.) 

Best Regards,

Liang 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[V-lianl-msft]

Hi @Gururajv007 ,

Based on your description,if the value of "Stage Final Index" depends on "Stage for Final report", you cannot sort "Stage for Final report by "Stage Final Index". You can also refer to following blog to know how to create a related sort table to enable sort by column feature: http://www.excelnaccess.com/custom-sorting-in-power-bi/

(Note: This link contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.)

Best Regards,

Liang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly