Issue with Repeated months and year not in order.

[Kolumam]

Hi All,

1. The first issue is the months are sorted but not the year.

2. The Month are repeated and not cumulatively summing up.

COS = CALCULATE(SUM(Project[Size (MWp)]),FILTER(ALL(Project),Project[COD] <= MAX(Project[COD])))

[rocky09]

@Kolumam

How is your data look like? I mean, Date with Time Stamp or just Date?

Second, you can set OFF Concatenate  labels under X-Axis option. So, You can see year wise on X-axis.  If data on X-axis shows year, just drill down to Months.

[Kolumam]

Hi

I used the below formula 

COD Month = DATE(YEAR(Project[COD]),MONTH(Project[COD]),1)

I put this COD Month in Axis now.

 and now it works fine but the issue is it shows from largest to smallest. Eg from Jan 19..Dec 18 instead of Dec 18 Jan 19

[rocky09]

@Kolumam

try to sort again.

OR

do one thing, go to query editor, create a custom column for the month like if [Month] = January then 1 etc.. once done, come back to the report then try to sort the COD by newly created Custom column.

[Kolumam]

It says that the column has been sorted directly or indirectly by another column.

[rocky09]

@Kolumam

did you tried to create a conditional column in query editor as i mentioned above?

[Kolumam]

Not working

[rocky09]

If possible can you show your data in query editor as well as on report?

[Kolumam]

Please see my thread.

The COD field was a date field which was in this format initially dd/mm/yyyy but I chananged it to Month Year

http://community.powerbi.com/t5/Desktop/Need-help-in-formula/m-p/374046#M169835

[rocky09]

The date was scrambled, can you post the sample data here? So, I can give you the proper solution.

[Kolumam]

Hi

The COS is a measure which has the formula which I posted long back. Somehow the COD is in descending order. When I transform it in bar chart, it starts from Jan 19, Dec 2018 etc...

Please find the below table.

[popov]

Hi,
Looks like you use sort order by COS in Chart. Change Sort Order.

[Kolumam]

No It is sorted by COD Month