Forum Discussion
How to Sort Visualization by Month
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?
