How to sort week proper order in bar chart Power BI

[Anonymous]

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

[Anonymous]

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)

Custom Sorting in Power BI 

Regards,

Xiaoxin Sheng

[lbendlin · Accepted solution]

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".