Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team ,
I have a table like below. This is how it comes in Transform data..
P1 | Copper |
P1 | Arrow |
P1 | Zinc |
Copper | |
P2 | Arrow |
P2 | Zinc |
P3 | Copper |
P3 | Arrow |
But when i select this column in DataTable it is sorting
P1 | Arrow |
P1 | Copper |
P1 | Zinc |
P2 | Arrow |
P2 | Copper |
P2 | Zinc |
P3 | Arrow |
P3 | Copper |
I Wanted in same order ...How to do it ..please guide me .
Thanks
Solved! Go to Solution.
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.
Use columnDefs option to remove sorting from a column. Pass column index in targets within [] (Indexing starting from 0) and set orderable to false . In the example, I removed sorting from email and salary column.
Regards,
Rachel Gomez
As @KeyurPatel14 suggested an index column would probably solve this. Don't forget to set the sort order by the index column, otherwise wasting time/effort 😅
Basic, but does the job.
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.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
83 | |
62 | |
62 | |
58 |
User | Count |
---|---|
157 | |
118 | |
103 | |
76 | |
66 |