Forum Discussion

hyeeun's avatar
hyeeun
Frequent Visitor
8 years ago

Display same month previous years on x axis based on filtered value

I have a report page with a Year-Month slicer. I want my column chart of to automatically show the same months previous years on x axis. For example, when 2018-05 is selected from my slicer, the char...
hyeeun's avatar
hyeeun
Frequent Visitor
8 years ago

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

hyeeun's avatar
hyeeun
Frequent Visitor
8 years ago

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's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi hyeeun,

     

    Could you please provide your demo pbix file for further test?

     

    Regards,

    Jimmy Tao