Forum Discussion

iabarraganc's avatar
iabarraganc
Helper I
4 years ago
Solved

selectedvalue from field in table visual

Hi dear members   I have the following situation. The report shows a table display with values. I need that when an item is selected in the table, the selected value appears in a separate card.   ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi iabarraganc 

    you can try

    Selected Color =
    SELECTEDVALUE ( Table, Table[Color] )

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi iabarraganc 

you can try

Selected Color =
SELECTEDVALUE ( Table, Table[Color] )

iabarraganc's avatar
iabarraganc
Helper I
4 years ago

Hi tamerj1 

That does not work, since the value is selected from a table display, not from a selector. And in my case it does not show the value. Any other suggestions?

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    iabarraganc 

    To be honest, I never tried that but as far as I know visuals filter each other why the CARD would be an exception. That's interesting. 
    I'm not on my PC right now so let's what other community members have to say about it. 
    As a test you may try

     CONCATENATEX ( Table, Table[Color], ", " )

    • iabarraganc's avatar
      iabarraganc
      Helper I
      4 years ago

      I also tried it. And it didn't work
      ☹️

      • amitchandak's avatar
        amitchandak
        Super User
        4 years ago

        iabarraganc , I checked both options provided by tamerj1  Should work. Unless I am missing an output which you need 

         

        Example

         

         

         

         

        Or

         

         

        Measure 2 = CONCATENATEX(Values('Table'[Color]), " Color " & 'Table'[Color] & calculate(SUm('Table'[Value])) & UNICHAR(10))