Forum Discussion
Helper IIIcan we remove default sorting option in data table power bi
Hi Ayappan ,
I have implemented the same scenario just like yours.
I can not say tha this is the ideal way to do this but if you can not find anyway then this might help you.
1. I added one index column in Power Query and gave the name as . as shown in below image.
For adding index column, Go to Power Query --> Add Column Tab --> General Section --> Index Column.2.Close and apply Power Query.
3.Take a table visual in PowerBI Desktop and add all the 3 fields and sort it by clicking on . column (which we added using Power Query) as shown in below image.4. Now make the last column very small that it can not be visible by dragging it towards left.
5. After all the steps it will look like the below image.
I know there might be many ideal ways to do this but if this post helps you or you find it intresting then give it a kudos and mark it as a solution.
Thank You.
Responsive ResidentHi Ayappan ,
I have implemented the same scenario just like yours.
I can not say tha this is the ideal way to do this but if you can not find anyway then this might help you.
1. I added one index column in Power Query and gave the name as . as shown in below image.
For adding index column, Go to Power Query --> Add Column Tab --> General Section --> Index Column.
2.Close and apply Power Query.
3.Take a table visual in PowerBI Desktop and add all the 3 fields and sort it by clicking on . column (which we added using Power Query) as shown in below image.
4. Now make the last column very small that it can not be visible by dragging it towards left.
5. After all the steps it will look like the below image.
I know there might be many ideal ways to do this but if this post helps you or you find it intresting then give it a kudos and mark it as a solution.
Thank You.