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.
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.