Forum Discussion
Dynamic Text Box - Make Value Blank When Nothing Is Selected
Hi All, I've got a dynamic text box that updates with whatever selection is made in a slicer. My question is, is it possible to have the Dynamic Text Bo be blank until someone selects something in ...
you need to have a measure for this, like:
SELECTEDVALUE(<columnName>[, <alternateResult>])
It returns the value when the context for columnName has been filtered down to one distinct value only. Else, alternateResult.
https://learn.microsoft.com/en-us/dax/selectedvalue-function
Okay....so I would have the alternate result be be the blank, correct?
Yes. You don't have to define because the default is also blank.
Term Definition
columnName The name of an existing column, using standard DAX syntax. It cannot be an expression. alternateResult (Optional) The value returned when the context for columnName has been filtered down to zero or more than one distinct value. When not provided, the default value is BLANK(). The questioner was not looking to create a measure but to use the dynamic text feature which is not usefull if you are using a slicer where all values can be selected, the dynamic text will return the first value. Any better idea how to use this feature instead of creating a measure??
