Forum Discussion

Himaja95's avatar
Himaja95
Helper I
2 years ago
Solved

Power Bi

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

Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    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.

4 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    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

  • v-zhangti's avatar
    v-zhangti
    Community Support
    2 years ago

    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.

  • Hema_Gupta's avatar
    Hema_Gupta
    Frequent Visitor
    2 years ago

    Hi,

    Hope this helps.

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