Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Modify DayOffset Slicer

Hi, I'm using dayoffset column from my Date table to filter visuals in the report. For one of my tabs in the report, I'm using the day offset as a slicer but it doesn't look intuitive or user friendl...
Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I've solved the issue by adding a blank query called "Now" that specifies the timezone and then referencing that "Now" query in the Date table i.e. the "Current date" step in power query.

vapid128's avatar
vapid128
Solution Specialist
4 years ago

OK  I don think my way gonna work for you. 

Unless you want to rewirte all measures.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

vapid128 I appreciate your help and feedback but is there another way without rewriting all measures? If not possible, then it's okay I'll seek further advise from other members in the forum.