Return the name of selected value when no slicer is used.

[brandeehuffins]

I have built a report that uses only 1 slicer for zone. The user click through a series of graphs to get lower level detail. How do i return the name of the item click in each visual? When i view what's filters it shows as just zone because that the slicer. I want to dynamically upate the visuals based on the selection in each visual.

[brandeehuffins]

Thank you

[technolog · Accepted solution]

You can create measure:

names = CONCATENATEX( 'YourTableName', [TableColumnName])  

And add this measure to Cards visualization=)