Forum Discussion

Dave1982's avatar
Dave1982
Frequent Visitor
5 years ago
Solved

Sort by Column Not Working for Month Number in Slicer

I have a data set that I have imported into Power BI that has an Outreach date column, Month, and Month Number column.  Date column is formatted as a date, Month is formated as text, and Month Number...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    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.⚡

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

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.⚡