topic Re: selectedvalue from field in table visual in DAX Commands and Tips

selectedvalue from field in table visual

iabarraganc — Fri, 06 May 2022 14:53:26 GMT

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

Re: selectedvalue from field in table visual

tamerj1 — Fri, 06 May 2022 15:23:39 GMT

Hi iabarraganc

you can try

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

Re: selectedvalue from field in table visual

iabarraganc — Fri, 06 May 2022 15:32:48 GMT

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?

Re: selectedvalue from field in table visual

tamerj1 — Fri, 06 May 2022 15:44:53 GMT

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], ", " )

Re: selectedvalue from field in table visual

iabarraganc — Fri, 06 May 2022 16:32:57 GMT

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

Re: selectedvalue from field in table visual

tamerj1 — Fri, 06 May 2022 16:38:18 GMT

iabarraganc

Alright let's wait together for an answer 😅

Re: selectedvalue from field in table visual

amitchandak — Sat, 07 May 2022 02:30:41 GMT

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

Example

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

Re: selectedvalue from field in table visual

iabarraganc — Mon, 09 May 2022 15:01:12 GMT

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