Forum Discussion
Using Different Date to Decide Status
v-henryk-mstf and AllisonKennedy thanks for you help and I figured it out 🙂
I just unpivoted the date columns and wrote a quick conditional column that created the needed status to put both data fields onto the shared axis.
Kmcdonald You're on the right track and definitely need a date table. Create an inactive relationship between Event Disposition Date (All) and the Date column from your Calendar table.
Then create two measures to put in your chart:
Count Open = Countrows(table)
Count Closed = CALCULATE( COUNTROWS(table), USERELATIONSHIP( calendar[date], table[Event Disposition Date (All)] ) )
Now if you want to split this by classification also, you'll have to do it as a drill down or be a bit more creative. Hope that makes sense?
Thanks AllisonKennedy , I created those measures but I can't get them into the shared axis of the chart?
The measure is formatted as a whole number but I can't move onto anything but the lines values or take over one of the column fields. That's unless there is something else I'm missing...Kmcdonald because they are measures, they can only go in Values. You could put classification in the shared axis and move them into the column values once the legend is empty, then drill down, but this won't give you the stacking you're looking for.
A custom visual like Charticulator or Deneb is the only way I know to create a clustered stacked column chart.