cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amysmith Regular Visitor
Regular Visitor

Re: Month Columns in PBI Desktop

teylyn Regular Visitor
Regular Visitor

Re: Month Columns in PBI Desktop

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

amerriwether Frequent Visitor
Frequent Visitor

Re: Month Columns in PBI Desktop

Teylyn,

Your solution is by far the best. and the only one posted here that works.  Good work.

 

Anthony

Highlighted
skocheta Regular Visitor
Regular Visitor

Re: Month Columns in PBI Desktop

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 Smiley Sad

 

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.