Power Bi

[Himaja95]

I added Description column to my data.

For Example, there is a filter named Exercise and the data in the column is walk,run,yoga.

the problem is if i chose walk ,runor yoga it is showing the correct description.However EVEN IF THERE IS NOTHING SELECT IN THE COLUMN THE DESCRIPTION SHOWS THE WALK DESCRIPTION.

Please Help

[Hema_Gupta]

Hi,

Hope this helps.

Instead of BLANK() you can pass any text which you want to show.

[v-zhangti · Accepted solution]

Hi, @Himaja95 

You can try the following methods.

Measure = SELECTEDVALUE('Table'[Description])

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anuja_Chaudhari]

[PijushRoy]

Hi @Himaja95 

I am not very cleat
What I understood, I am trying to provide a solution
Create a measure and use the Measure in your visual

MeasureName = VAR _selection = SELECTEDVALUE('table'[walkzogaruncolumn])
RETURN
SWITCH(
TRUE(),
_selection = "zoga","the text you want to show" or column,
_selection = "run","the text you want to show" or column,
_selection = "walking","the text you want to show" or column,
"default text you want to show when no filter selected" or column or BLANK()
)

Please use proper column and text in above dax

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS