Forum Discussion

Treawlony's avatar
Treawlony
Regular Visitor
7 years ago

Previous month based on slicer

HI All,

I need to have one graph of a report page that shows data of a month AFTER the one selected in the slicer

 

i.e: I select SEPTEMBER, I see SEPTEMBER data on the page, but one graph must show OCTOBER one.

 

I can't find any way to do that and also can't ifnd a way to use DAX

 

Anyone can help me?

 

Thanks

Need Help

10 Replies

  • Watsky's avatar
    Watsky
    Icon for Solution Sage rankSolution Sage
    7 years ago

    You could make a calculated column with the function DATEADD to add another month to your date column then in your graph replace the original date with the new calculated column.

     

    Next Month =
	DATEADD ( [DATE], 1, MONTH )
    • Treawlony's avatar
      Treawlony
      Regular Visitor
      7 years ago

      This would not work, because the graph itself has no date filter in it, it's on a page level.

      So You would just swith che problem to all other graphs, that should be one month back :)

       

      On a logic perspective, I just need that the graph shows me the data of the NEXT month I select in the general slicer

       

      • Watsky's avatar
        Watsky
        Icon for Solution Sage rankSolution Sage
        7 years ago

        Is the date is not on your graph as an axis?  Do you just have values and other attributes on the axis? Can you screenshot your graph?