Sorting columns in stacked column chart

[MEFOX]

I have a stacked cloumn chart with Event Name on the axis. I want to be able to sort the columns by a date but when I try to select the StartDate field from the Sort By Column I get the error below. The startdate I'm trying to sort on is in the same table as the Event Names column. Is there another way to perform this sort?

[edhans]

You need to have a sort column that is a 1:1 match with the column you are sorting. You probably have it set where you want to sort a column by date, but there are multiple dates per item. So the Event Name might have Jan 1, 2021 and Jan 2, 2021 associated with it. Won't work.

You need to come up with some logic that will be unique. A new column that is just year and month perhaps?

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.