• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Issue with Sorting by month


New Member
I have issue in visualization by sorting by month. It provides me error message. Also I am not able to upload the file due to PBIX. I have created a column in calendar month stating
overdue = IF(Calendar1[CurMonthOffset]<0,".Overdue",Calendar1[Month])
i can create the visualisation but when i am trying to sort it it gives me error message. If you can help me in this regards. Thanks


GraH - Guido

Well-Known Member
The error message seems to indicate you have multiple current fiscal year offset values for a same overdue value. This suggest you datamodel might not be optimized for the visualization you want to make.
Without seeing the datamodel it's not easy to give clear advice. You can upload pbix files here as others have done it before.