Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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".
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)
Regards,
Xiaoxin Sheng
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".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |