Forum Discussion
Sort by Column Not Working for Month Number in Slicer
Dave1982 that measure you month number value for the same month is not consistent.
For example, in some rows for the month of April, the month number is 3 or 4 or another value, basically, each month should have the same month number value. Check your data. Seems like there is inconsistency in your data.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Super UserDave1982 based on your original post, the following doesn't make sense. Why you are sorting the date column by Month Number, as suggested by others, you need to sort Month column by Month Number not Outreach Date column by Month Number.
I have used the sort by column on the outreach date and selected the Month Number column
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2k The reason is that when I sort by Month and Month Number I get an error that is returned to me.
- Burningsuit
Resident Rockstar
Yes, your "Month Number" column is incorrect, with different values for a single month. How are you getting that column ? Probably the simplest way is to generate a calculated column like..
Month Number = month(TableName[Outreach Date])
Stuart
