Forum Discussion

iabarraganc's avatar
iabarraganc
Icon for Helper I rankHelper 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
Icon for Community Champion rankCommunity 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
Icon for Helper I rankHelper I
4 years ago

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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper 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))

     

     

     

     

     

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    iabarraganc 

    Alright let's wait together for an answer 😅