Forum Discussion
Filters affecting Dynamic Text
Hi Anonymous
That greatly depends on the values being used in your text box visual. It's blank because the value is out of context for the filters being applied. Can you share a sample calculation for one of the dynamic values?
hnguy71 yes sorry if that was confusing at all.
For the screenshot where it shows "11/1/2024", that is coming from this calculated column:
In this DAX calculation, STARTDATE is just the current date, and it is populated for every row in the dataset. I am effectively truncating it to the beginning of the month.
hi Anonymous ,
try like:
STARTDATE_BOM =
EOMONTH(MAX(DEMAND[STARTDATE]), -1)+1
Unfortunately this results in the same outcome with the value not populating
Hi Anonymous ,
And how are you selecting the date? What's the measure value inside your text box?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:
