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...
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: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.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:
