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.
I have a report powering a dashboard visualization which I would like to sort by month (text names). Currently, they display out of order. Investigating this issue, I see other discussions where it was recommended to create a month sort column (numeric values for months) and then sort the Month column by the Month Sort column. Unfortunately, I am not having any luck with this either. I created the column without issue, but when I attempt to sort Month by Month Sort, I receive the following error: "Sort By Another Column Error. This column can't be sorted by a column that is already sorted, directly or indirectly, by this column".
I apologize about the lack of screenshots. I am not familiar with the PowerBI community and am unsure how to attach them (clicking insert/edit image does not have an option to browse and select a file from my computer).
Thanks in advance for any assistance that can be offered regarding this issue.
Did you create the sort-column as an calculation based on the origin column?
Then you should move the calculation from the calculated column in the model to a new column in Power Query, like described here:
https://community.powerbi.com/t5/Desktop/Sort-by-another-column-error/m-p/61355
I did not. Actually, the column is literally straight numbers within the associated spreadsheet. As I simply needed 1-12, I manually entered them as opposed to writing an equation for it. i.e. Column A (Sort Order) contains numbers 1-12 (A1=1, A2=2, etc.) formatted as Numbers. Column B (Month) contains January-December formatted as text. There is no equation from one column to populate the other in either direction.
OK.
Unfortunately I did not succed in duplicating that effect.
Could you upload your file (after you anonymonized the containing data) so I could play with it and the effect?
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 |
---|---|
116 | |
102 | |
77 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |