Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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:

STARTDATE_BOM = DATE(YEAR(DEMAND[STARTDATE]),MONTH(DEMAND[STARTDATE]),1)

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.
hnguy71's avatar
hnguy71
Super User
1 year ago

Hi Anonymous ,
And how are you selecting the date? What's the measure value inside your text box?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    I input the measure as a value in the text box like this:

     

    • hnguy71's avatar
      hnguy71
      Super User
      1 year ago

      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: