The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I am not able to sort the column and save it. In the power query, the sorting is done correctly but in table view the sorting disappears and when restarting again back to normal. No sorting works. Please help
Solved! Go to Solution.
Sorting in powerquery does not follow through into power BI.
You can apply custom sort orders to columns within Power BI which will be reflected in visuals
Hi @hiren_1222 It's because Power Query transforms the data but does not control visual sorting in Power BI. To address this:
Index Column in Power Query: Add an index column in Power Query to preserve the desired order. Then, in Power BI, sort your column by this index.
Custom Sort in Power BI: For specific orders like months or categories, use "Sort by Column" in Power BI and select the appropriate column for sorting.
For more details please go thhorugh the link that @Deku has shared
If this post helped please do give kudos and accept this as a solution
Thanks In Advance
Hi @hiren_1222 It's because Power Query transforms the data but does not control visual sorting in Power BI. To address this:
Index Column in Power Query: Add an index column in Power Query to preserve the desired order. Then, in Power BI, sort your column by this index.
Custom Sort in Power BI: For specific orders like months or categories, use "Sort by Column" in Power BI and select the appropriate column for sorting.
For more details please go thhorugh the link that @Deku has shared
If this post helped please do give kudos and accept this as a solution
Thanks In Advance
Bro, tried everything. Nothing works
Sorting in powerquery does not follow through into power BI.
You can apply custom sort orders to columns within Power BI which will be reflected in visuals
User | Count |
---|---|
83 | |
82 | |
34 | |
33 | |
32 |
User | Count |
---|---|
93 | |
79 | |
62 | |
54 | |
51 |