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.
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.
@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?
Hi @v-yulgu-msft do you have a solution on the ordering from oldest to newest?
Hi @v-yulgu-msft I was just wondering if you know a siolution to sort from oldest to newest. Thanks.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!