Forum Discussion
Filters affecting Dynamic Text
Hello, I have a text box that populates key dates for a given report. These dynamic values sometimes will not populate when the user filters the report, and I can't understand why. Has anyone com...
I input the measure as a value in the text box like this:
Hi Anonymous
Because that column is a calculated result, it doesn't update according to the filter context being applied. You'll need to create a measure and then replace your STARTDATE_BOM with the new measure.
Step 01: Create a measure:
Step 02: Insert code, replacing "Table" with your actual table name:
StartOfWeek =
VAR _SelectedDate = SELECTEDVALUE('Table'[Date], MAX('Table'[Date]))
RETURN
_SelectedDate - WEEKDAY(_SelectedDate, 3)
Step 03: Replace your dynamic text with your new measure name and click save:
As an example output, you can see if I select December 03, I return Dec 02 as my start of the week: