Dynamic Text Box - Make Value Blank When Nothing Is Selected

[PowerBINoob24]

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 the slicer?  Right now if nothing is selected in the slicer the dynamic text box will default to the the first item in the slicer.

Thanks in advance!

[lukiz84]

Hi,

please post the measure.

br

[PowerBINoob24]

There is no measure.  It just pulls values from a column.

[lukiz84]

Then how should this work? Use a measure instead.

[PowerBINoob24]

I'm pulling in text, not numbers.  Not sure how one turns text into a measure.

[grandtotal]

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

[PowerBINoob24]

Okay....so I would have the alternate result be be the blank, correct?

[grandtotal]

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().

[exception]

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