Forum Discussion

gonrodrigues's avatar
gonrodrigues
Helper III
10 years ago

Dashboard refresh issues

Hello,   I'm struggling with PBi to show data from last month by default either in reports and dashboard. I've seen some different techniques:   1. Creating a column with CurrentMonth and put it ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Typically it looks something like creating a new column with a formula like:

 

DaysPast = DATEDIFF([Date],TODAY(),DAY)

You can then set your filter to something like >30

  • gonrodrigues's avatar
    gonrodrigues
    Helper III
    10 years ago

    But then everything will be filtered right? Slicers included.. I want slicers to have other months/years in the options and not only '< 30'

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      10 years ago

      Use a visual level filter then versus a report or page filter.

      • gonrodrigues's avatar
        gonrodrigues
        Helper III
        10 years ago

        That doesn't work either. When i select other month in slicer, graph show no data because is filtered :S

         

        I need all graphs to show last month by default, but also be able to show data from other months.

         

        Thanks Greg_Deckler