I feel like the answer to this is going to be simple and i have read and tried the solutions in other forums but i still cant get it to work.
I am using Sams date table and have added a Short Month column into the table and want to use this as a slicer in my visualisation. When i use it in the slicer the order of the months is not in the correct month order e.g Jan, Feb, Mar etc instead the order is Apr, Aug, Dec, Feb, Jan, Jul, Jun, Mar, May, Nov , Oct Sep?? i have read in other solutions to use the Sort by Column function and sort using the MonthnYear column but when i try this i get an error message saying ‘There cant be more than one value in " monthnyear for the same value in Short Month. Please choose a different column for sorting or update the MonthnYear’