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