selectedvalue from field in table visual

[iabarraganc]

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.

For example, if I have the following data in the table

Date	Color	Value
20220115	Red	2500
20220131	Blue	3100
20220203	Yellow	750

If the user selects the second column, third row, in the card appears "the selected value is Yellow". And if the user selects the second column, first row, the card shows "the selected value is Red" (with DAX, of course).

I can't use a slicer, as the other data needs to be displayed and the highlighting functionality is not lost.

Thanks for your help

[iabarraganc]

Dear friends

Thank you very much for all the help. Let me tell you: if you use the DAX formula on a card, it displays well. But if the DAX formula is used in the title of a visualization, it is frozen and does not show the calculated value.

The solution: remove the title from the chart and place a card over the visualization, with the formula that @tamerj1 mentioned.

To both of you, thanks for the help

[tamerj1 · Accepted solution]

Hi @iabarraganc 

you can try

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

[iabarraganc]

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]

@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]

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

[amitchandak]

@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]

@iabarraganc 

Alright let's wait together for an answer 😅