Compare PY Month Total to CY Month Total

[JCBI1023]

Hello eveyone, thank you in advance.

I want to create a clustered bar visual that compares Previous Year (PY) GP/GP% to Current Year (Year) GP/GP% by Month.

For Example, I want a clusted bar chart that shows PY Nov to CY Nov, etc.

Here's a screenshot of my data:

I have a Date table, with a Relationship setup to the Date Column of my data.

Dates = CALENDARAUTO()

Month = FORMAT('Dates'[Date],"MMMM YYYY")

Month ID = 0 -INT(FORMAT('Dates'[Date],"YYYYMM"))

Year = YEAR('Dates'[Date])

I am a novice level PowerBI guy. I have done some simple DAX/Measures, but nothing too serious. Please let me know what other information can help. 

[v-yulgu-msft]

Hi @JCBI1023,

Insert a clustered column chart, place date field into Axis and legend section in hierarchy format.

In my test, the calendar table was not used.

Regards,

Yuliana Gu

[JCBI1023]

@v-yulgu-msft This looks great and I was able to accomplish this. Now, how do I get the clustered bars going from latest to newest? In other words, I want November 2016/2017 first, then December 2016/2017, then January 2017/2018?

[JCBI1023]

Hi @v-yulgu-msft do you have a solution on the ordering from oldest to newest?

[JCBI1023]

Hi @v-yulgu-msft I was just wondering if you know a siolution to sort from oldest to newest. Thanks.