Filters affecting Dynamic Text

[cbschley]

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 come across this, and if so, how to prevent it?

Text box description showing dates, unfiltered:

When user filters the report using the side-bar filters:

[hnguy71]

Hi @cbschley 

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?

[cbschley]

@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]

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

[cbschley]

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

[hnguy71]

Hi @cbschley 

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:

[FreemanZ]

hi @cbschley ,

try like:

STARTDATE_BOM =

EOMONTH(MAX(DEMAND[STARTDATE]), -1)+1

[cbschley]

Unfortunately this results in the same outcome with the value not populating