Forum Discussion

paulwozniak's avatar
paulwozniak
Icon for Helper I rankHelper I
9 years ago

Dashboard refresh - show today's data

I have a dashboard based on tiles in a report that has a date slicer. When I pin a visual to a dashboard from this report it freezes at the filter context at the time of the pinning. That makes sense...
Need Help
paulwozniak's avatar
paulwozniak
Icon for Helper I rankHelper I
9 years ago

I've added a Today column in my Date table which calculates whether the date in that row is today or not. I've then used the Today column as a slicer. It has two values in it, Yes and No. When I select Yes it filters data for today only. It seems to work so far with the visuals in the dashboard after I've pinned them while only having Yes selected in the Today slicer.

 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi paulwozniak,

     

    Excellent solution! Could you accept your reply as solution to help others who has similar issue easily find the answer and close this thread?:smileyhappy:

     

    Regards

    • paulwozniak's avatar
      paulwozniak
      Icon for Helper I rankHelper I
      9 years ago

      I would v-ljerr-msft, but I think it might not be working as well as I first thought. 

       

      See this post.