Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
@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 I was just wondering if you know a siolution to sort from oldest to newest. Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |