Forum Discussion
Selected Values in Slicer
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
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
5 Replies
v-jiascu-msftMicrosoft Employee
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
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
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
