cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vilasvarma
Regular Visitor

How to sort week proper order in bar chart Power BI

Sample data

Funnel_IdSnap_weekStage Name
3DMCR-OPP111263:Week 1week 10Closed Won
3DMCR-OPP111249:Week 1week 8Closed Won
3DMCR-OPP111570:Week 1week 9Validate Opportunity
3DMCR-OPP111645:Week 1week 6Understand Opportunity
3DMCR-OPP111536:Week 1week 7Closed Lost
3DMCR-OPP111587:Week 1week 5Closed Lost
3DMCR-OPP111588:Week 1week 3Closed Lost
3DMCR-OPP111529:Week 1week 4Negotiate & Close/Contract  Approval
3DMCR-OPP111555:Week 1week 1Closed Won
3DMCR-OPP111726:Week 1week 2Qualify Opportunity

Oppty report.png

 

 

 

 

 

 

 

Regards

Vilas

1 ACCEPTED SOLUTION
lbendlin
Super User
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".

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @vilasvarma,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
lbendlin
Super User
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".

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors