Forum Discussion

Vsevolod_Klivak's avatar
Vsevolod_Klivak
Frequent Visitor
5 years ago

Brainy data slicer

Hi all, 

 

I have the following issue: I have streaming data, but for instance it is not updated on the weekends. But I would like to see Friday updated info on Sunday. Is it feasible to make relative data slicer, where the last date is the last date with specified data, not the current "today"?

 

Will be glad to hear ideas and comments!

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    There are a couple of ideas posted on ideas.powerbi.com for what you are trying to do.

    In the meantime you can achieve that with separate slicers and using the fact that Power BI remembers a slicer selection title.  So you can create a calculated column that replaces your most recent timestamp with  "Latest transaction date", and then use that calculated column as the source for your slicer etc.