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.
Hi,
I have table like this
I would like to have a visualization table like this and the top row sorted by weeknum descending. but BI always sort it ascending. I checked lot of topic but can't find a solution. the weeknum is in whole number format.
Thank you.
Solved! Go to Solution.
I found that I can sort it in the report after I submitted to the web. just go to that visualization at right corner and select sort by weeknumber then done. it's not working in desktop.
thank you everyone.
Hi,
I would like to have the 201803 in the first column, then 201802... etc.
@ericbi,
Please follow the steps below.
1. Create a conditional column in Query Editor of Power BI Desktop.
2. In report view of Power BI Desktop, click the Week column in your tables, then choose "Sort by column" to sort the Week column by the Custom column(conditional column).
Regards,
Lydia
Thank you Lydia. but my report has scheduled refresh, so the weeknumber will be added automatically, I would like to find a way to sort it by itself.
thanks again.
Credits to @ipsingh79 in an earlier forum post. I checked his solution and that works:
Please check if all weeks are correctly filled like 201801, 201818, etc. This must be correct to let the solution work.
Open Edit Query --> Add custom column as : SortWeek = 999953 - [Week]
Apply and Close the query editor
Sort the original Week column with the custom column "SortWeek"
Matrix will be correctly sorted (201803 as first column)
I found that I can sort it in the report after I submitted to the web. just go to that visualization at right corner and select sort by weeknumber then done. it's not working in desktop.
thank you everyone.
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |