Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I work at a college and have a term (semester) field, an example would be 2014fall and 2015fall. The terms started on different dates (off a few days each year say 2014 was 10/11 and 2015 was 10/14). I have a slicer set up to show 2014fall and 2015 fall on a cluster column chart. Now I want to compare them. They show up in the graph as two separte mini graphs (one in 2014 and one in 2015) because the x axis has dates, when I want them side by side, but the dates don't match. I have date in axis, term in legend and headcount in value fields for the chart. I also created a DAX function called datelastyear (subtracted 363 days from this years dates) but not sure how to use it in the graph if I need it. HELP!
Solved! Go to Solution.
Do you have a date lookup/dimension table?
If so, you could create a column called semester_day which had a number 1 to 365 starting on the first day of the semester, you could also have the same for semester_week 1 to 52.
You could then use semster_day (or week) as the X axis, headcount for the value and semester year as the legend.
If you added a weekday column (just containing the name of the day) as well you could do analsyis comparing the days of the week to see which had the highest headcount
So, you should be able to replace Date with DateLastYear for this year's data in the x-axis and then the dates should match, right?
Do you have a date lookup/dimension table?
If so, you could create a column called semester_day which had a number 1 to 365 starting on the first day of the semester, you could also have the same for semester_week 1 to 52.
You could then use semster_day (or week) as the X axis, headcount for the value and semester year as the legend.
If you added a weekday column (just containing the name of the day) as well you could do analsyis comparing the days of the week to see which had the highest headcount
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |