Visual Level Filter Equal To Column Value

0
votes

I have a measure in my date table that calculates the week number of the year for last week. LastWeekNum = WEEKNUM(TODAY(), 1) -1

I want to apply this to a visual, so logically: WeekOfYear = LastWeekNum.

Is there some way to set this up?

1
powerbi

1 Answers

1
votes

This is possible to do with some DAX and model editing, but I'd first try using Relative date filtering in the visual level filter settings to see if you can do it the easy way.

Relative Date Filtering

If that doesn't work, I'd suggest creating a Boolean column on your date table and using that column to filter your visual instead. Visual level filter, Basic filtering, IsLastWeekNum is 1

IsLastWeekNum = IF(WEEKNUM(DateTable[Date]) = [LastWeekNum], 1, 0)