Forum Discussion
How to sort week proper order in bar chart Power BI
Sample data
| Funnel_Id | Snap_week | Stage Name |
| 3DMCR-OPP111263:Week 1 | week 10 | Closed Won |
| 3DMCR-OPP111249:Week 1 | week 8 | Closed Won |
| 3DMCR-OPP111570:Week 1 | week 9 | Validate Opportunity |
| 3DMCR-OPP111645:Week 1 | week 6 | Understand Opportunity |
| 3DMCR-OPP111536:Week 1 | week 7 | Closed Lost |
| 3DMCR-OPP111587:Week 1 | week 5 | Closed Lost |
| 3DMCR-OPP111588:Week 1 | week 3 | Closed Lost |
| 3DMCR-OPP111529:Week 1 | week 4 | Negotiate & Close/Contract Approval |
| 3DMCR-OPP111555:Week 1 | week 1 | Closed Won |
| 3DMCR-OPP111726:Week 1 | week 2 | Qualify Opportunity |
Regards
Vilas
Add another column with the numeric week value, and then sort your Snap_week column by the new column.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hdFBC4IwGMbxrzI8G23TTesWdqy0oDyYh5ErJNlEZ+G3b3mJXkFv/8vvZTzLMsfb7qPTIk4SQgjl3jqV8omI4zrvIbCtqNKtLFCqlZO7QPgrIMJpwAIMwMrGRVRlIYxEcV3rxnSqNP2Icp8Bym2cVSGb1ghVTGLmcYCD30N3ujVjEQZAsFkRAuHNCQrn820c5EOb8jvHtcOYcjScWEZamUbcDEKbum70S1TjewxORKa/I6BwFmrj2Nn/uPf/g+Yf", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Funnel_Id = _t, Snap_week = _t, #"Stage Name" = _t]), #"Added Custom" = Table.AddColumn(Source, "Week #", each Int16.From(Text.Replace([Snap_week],"week",""))) in #"Added Custom"How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".
2 Replies
- lbendlin
Super User
Add another column with the numeric week value, and then sort your Snap_week column by the new column.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hdFBC4IwGMbxrzI8G23TTesWdqy0oDyYh5ErJNlEZ+G3b3mJXkFv/8vvZTzLMsfb7qPTIk4SQgjl3jqV8omI4zrvIbCtqNKtLFCqlZO7QPgrIMJpwAIMwMrGRVRlIYxEcV3rxnSqNP2Icp8Bym2cVSGb1ghVTGLmcYCD30N3ujVjEQZAsFkRAuHNCQrn820c5EOb8jvHtcOYcjScWEZamUbcDEKbum70S1TjewxORKa/I6BwFmrj2Nn/uPf/g+Yf", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Funnel_Id = _t, Snap_week = _t, #"Stage Name" = _t]), #"Added Custom" = Table.AddColumn(Source, "Week #", each Int16.From(Text.Replace([Snap_week],"week",""))) in #"Added Custom"How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".
HI Anonymous,
You can refer to the following link to create a custom sort table with particular index and legend values and link the fact table field to achieve custom sort order. (create a new table and set the index of these values, use relationship link to raw table field and use sort table fields to replace raw field on your chart)
Regards,
Xiaoxin Sheng