Adding a filtered column to a data set

[Anonymous]

Is this possible?

This is what normally happens:

This is what I want to happen:

Background:

I have a R - Visual that accepts data points to draw a graph.  It has to draw a graph that wil draw the filter selected data point in a different color.  If the whole dataset is filtered the graph looks wonky.  This way the first value of the "Selected" column can be used in R to identify the data point that has to be drawn in a different color.

[Greg_Deckler · Accepted solution]

Sure, create a table like this:

SlicerTable = DISTINCT('Table'[Name])

Make sure this is disconnected from any other tables. Use this in your slicer.

Create measure:

Selected = SELECTEDVALUE('SlicerTable'[Name])

Put that measure in your table visualization

[Anonymous]

I knew it had to be easy 😋

It's perfect!

I added to it to remind me if I perhaps selected more than one value

SelectedName = IF(HASONEVALUE('SlicerTable'[Name]), SELECTEDVALUE('SlicerTable'[Name]), "One name please")

Thank you Greg!