Forum Discussion
Comparing months from 2 years
hi, I've 2 columns in a table where I'd like to compare data. The columns are named event start date and status. Status contains data like registered, cancelled etc. The event start date has the...
Anonymous, try this solution:
1. Create a stacked column chart.
2. Create a year/month hierarchy and add it to Axis:
3. Add the Status column to Legend.
4. Add the measure to Values.
5. In the chart, click Expand all down one level in the hierarchy:
6. In Format --> X axis, turn off Concatenate labels:
Result:
DataInsights Ok, it looks like I solved it. I created a new column in my original table [eventstartdate].[date] and then matched to date column in date table.
Thanks again.
Anonymous, glad you solved it.
For reference, here's the DAX for a calculated column that can be joined to the date column in the Date table:
Start Date = INT ( Event[Start Datetime] )