Filtering Data in the Visuals

DAX
2

Take a look at @Melissa’s absolutely awesome calendar table
With this table, you can build in logic to filter your data by the week offset value.
Ex: Current week would be offset #0, and prior week would be offset # -1

a couple of other notes - which may not be needed, as this is just a sample:

  1. Always mark your date table as a date table (right-click on the table name in the model to do this)
  2. I suggest hiding your connection fields (like date on the Sheet 1 table) - this will prevent you from accidentally using those in a visual and messing up your filter logic.
2 Likes