Forum Discussion
Sort column Values in Power BI
Hi, I am new to Power BI. I have one requirement to sort 'QTR_Yr' column values in a table. For that I have created one table with 'Qtr_Yr' column from the main table and added one more column '...
Hi Anonymous,
Could you have tried add the index column in query editor?
Reference:https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Regards,
Daniel He
Hi Anonymous,
Could you have tried add the index column in query editor?
Reference:https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Regards,
Daniel He
Hi v-danhe-msft,
Actually the issue was different. The values which I mentioned above has special characters in it. eg. 'RST Q3'17' has special character in it. so I am not able to compare it with Qtr_Yr column. But thanks for the suggestion. Adding index is a good idea if we enter the data in the column manually.
Thanks!
Regards,
Poonam