Filters affecting Dynamic Text

Question

Hello,&nbsp;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:&nbsp;&nbsp;When user filters the report using the side-bar filters:&nbsp;

hnguy71 · Answer

Hi&nbsp;Anonymous&nbsp;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:&nbsp;StartOfWeek = 
 VAR _SelectedDate = SELECTEDVALUE('Table'[Date], MAX('Table'[Date]))
 RETURN
 _SelectedDate - WEEKDAY(_SelectedDate, 3)&nbsp;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:&nbsp;

hnguy71 · Answer

Hi&nbsp;Anonymous&nbsp;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.&nbsp; Can you share a sample calculation for one of the dynamic values?

anonymous · Answer

hnguy71&nbsp;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.

freemanz · Answer

hi Anonymous&nbsp;,
&nbsp;
try like:
STARTDATE_BOM =
EOMONTH(MAX(DEMAND[STARTDATE]), -1)+1

anonymous · Answer

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

Forum Discussion

Filters affecting Dynamic Text

7 Replies

Related content

Dynamic Filter

Measure not affected by filter

Dynamic Filtering

Dynamic measure filtering

dynamic x-axis based on filter