Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am trying to sort my data by Month, so that it appears in the correct month order in my various visuals.
There are multiple lines per month based on client data, each line with the corresponding Month and Period (month number).
I am getting the error "We can't sort the 'Month' column by 'Period'. There can't be more than one value in 'Period' for the same vlue in 'Month'. Please choose a different column for sorting or update the data in 'Period'."
I have tried adding a calculated column for month number and sorting that way. Same error.
I have tried adding a conditional column and feeding it every month name and month number and sorting that way. Same error.
I have double checked my data. Every line has the correct month name and correct corresponding month number.
Any other ideas?
Thanks~
@jsralat I cannot recreate this. See PBIX. The most obvious cause for this would be some type of mismatch between your two columns like a "January" and a 2 or, a "January " and a 1. Note the trailing whitespace in the second example. Perhaps try applying a clean and trim operation on your Month column as well as Period just to be sure.
I went back to my data and found two rows with (blank) for Month and Period. I assigned them a month and period just to test. I then also re-typed the months and corresponding month number in Period, ensuring they were consistent, just to make sure. Refreshed my data and I'm still getting the same error when I try to sort Month by any other column. I'm at a loss.
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |