Forum Discussion
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...
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 , you have date table linked to one table for your example so countrows will be for 'dw_orders' table only. I will be linking to multiple tables - how do I accomplish that?
vapid128
Solution Specialist
Solution SpecialistTry make all relationship cross filter diretion both.
If it does not work, can you pos all your table relationships?
vapid128 I'm not comfortable setting cross filter to 'both' direction as it may cause ambiguity with results when filtering. I direct messaged you with link to pbix file. Hope that's okay.