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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors