Hi, if you wish, you will be able to learn more here:
@amysmith, you are not attempting to answer the question. The link just leads to a generic landing page in your site. I assume you posted that link to attract traffic. I have reported your post as spam.
Hello @teylyn, Thanks for your post. It works absolutely fine for most of the scenarios. However I have a further complexity to this.
I use Live Data sources (SQL as well as Power BI As a Data source), so "Sort by Column" is not an option and is disabled.
I am trying to create a Line chart for Revenue as well as Linear and Fiscal Revenue targets.
This works fine if I have Months number in X Axis , but for obvious reasons, I can't do that.
The Only solution that I could think of is, to create a custom column which has value like 01Jan 02 Feb etc.
This is not very clever and user friendly
Could you please help if you could think of any alternative.
This is a very basic scenario and I believe many people would have faced this.