Forum Discussion
Display same month previous years on x axis based on filtered value
Community SupportHi hyeeun,
You can create a calculate column using DAX formula as below and create a slicer chart based on the new column:
Month Column = MONTH ( Table[Date] )
Then you can use the slicer to filter the chart you have created.
Hope it's helpful to you.
Jimmy Tao
Thanks for your comment Jimmy but I don't think my question was clear.. The month I'm refering to is already in DAX and have a slicer. I am trying to have my column chart to show same month previous years as shown on the image below(on the right) but my slicer is limiting it to only show the value like the image on the left b/c "2018-05" is selected from the filter.
current outputdesired output
The only way I can get this to work is creating two slicers; one for Month and one for Year and turning off the filter interactivity from the Year slicer to the chart so it only reposponds to Month slicer. This however messes up with another visual I created which is a percent change calculation from the previous month. There must be more sophisticated way of achieving this. Anyone??
- v-yuta-msft