Forum Discussion
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.
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
7 Replies
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
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?
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 tryCONCATENATEX ( Table, Table[Color], ", " )
