Selected Values in Slicer

[mikmokmuk]

Hi guys,

we are trying to get the values selected in a given slicer. Idealy, we would like to return it as a text format. For instance, we have a slicer with the values:

A [  ]

B [X]

C [X]

Would be possible to return something like "BC".

Thank you,

M 

[v-jiascu-msft]

Hi @mikmokmuk,

Please try the formula below.

//if there isn't any selection, this formula will return all the values. So ISFILTERD is here.
SelectedInSlicer =
IF (
    ISFILTERED ( DimProduct[ColorName] ),
    CONCATENATEX ( VALUES ( DimProduct[ColorName] ), [ColorName], "-" )
)

Best Regards,

Dale

[mikmokmuk]

Hi Dale,

thank you for your reply. We have tried your suggested formula and is not working, see screenshot. I have attached a sample of out pbix file here in dropbox. Would you mind to take a look into?

https://www.dropbox.com/s/eef2twfw72gp1gt/EXERCISE.pbix?dl=0

Many thanks,

Mik

[v-jiascu-msft · Accepted solution]

Hi Mik,

It should be a measure rather than a calculated column. Please try it. The calculated column won't respond to the slicer for now.

Best Regards,

Dale

[Sean]

@mikmokmuk

In addition to the solution provided by @v-jiascu-msft 

Look at my solution here...

https://community.powerbi.com/t5/Desktop/See-visually-what-filters-have-been-applied/m-p/178196#M779...

It includes the above but can also give you some ideas on how you can modify the Measure further.

One thing you may consider is limiting how many items you list in the Card Visual before you say “Multiple”

Hope this helps! 

[Anonymous]

I successfully created a measure that returns the value selected in the slicer - thank you! but now, I'd like to use this measure to calculate a column with the expression "If ('Table'[Year} <= ValueSelectedInSlicer, "Reached Phase","Did Not Reach Phase") for all rows. But someone mentioned this earlier, that we cannot use the measure that returns the value selected in the slicer in a column. Is there an alternative way to execute what I'm describing?