Forum Discussion

polaris3028's avatar
polaris3028
Helper III
8 years ago

Sort Graph by Month and Year

Hi All,   Help needed. Can I have this graph sorted to have (left to right), Jan 2018, Dec 2017, Nov 2017 so on...?   Thanks, Paul
Need Help
polaris3028's avatar
polaris3028
Helper III
8 years ago

Hi  Jordan - not sure what source of what data you're asking.  The Date table was created in PowerBI itself (as a query).  The data is coming from Google sheets. 

 

So, basically I have two tables, one as datasource and a Date table for the calendar.  The X-Axis presented in this graph that I wanted to sort out is using the concatenated Month and Year columns from the Date table.  If I have to create a new column like what you said with Index, which table should I create it? and How?

 

Thanks

 

JordanJSA's avatar
JordanJSA
Frequent Visitor
8 years ago

Hi Polaris, 

 

I've been looking into this and I'm not sure that this can be done within PowerBI. The index feature within PowerBI naturally orders the values 1,2,3.. Which wouldn't return the output you need. An alternative would be to create the index within Google docs if possible and then once loaded into PowerBI you would have the order that you require and you could sort by this value. 

 

thanks