From looking online it looks like you cannot put a measure on the x-axis of a chart. This kinda makes sense, however it would be good in some circumstances.
Can anyone help out with an idea for the following scenario. I’m showing measures on a chart.
If the year is selected is a slicer, i want to show the Months on the X-Axis, if a month is selected in a slicer then show Day on the X-Axis.
I can to the logic for a measure using ISFILTERED(‘Date’[Month]).
The backup solution is to live with it and use drill down, but i’m trying to have the charts more dynamic.