Forum Discussion
Retrieve multiple selected values in grid from slicer
Here is the scenario-
I want to show the multiple selected values from slicer into grid.
SELECTEDVALUE function is working fine for single selected value but not for multi-select values.
Above fig shows count of slicer for single value. I want to have similar count for mutli-selection. For instance, if I select 1,2 and 3 then grid should show the values as 1,2 and 3.
Here, I am able to able to get the values in string format by using below DAX-
selectedvalues=CONCATENATEX(ALLSELECTED(CATEGORY3),CATEGORY3,",")
Is there any other solution for this ? Also,further I want to pass those values into other DAX.
Thank you in advance.
In this senario, you don't need to create any measure, just enable the interaction between table visual and slicer visual.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
yes, FILTERS() is also working for single selection of slicer and not for multi-selection same as SELECTEDVALUE().
Hi,
Can you use VALUES() DAX. Please refer the below article.
https://community.powerbi.com/t5/Desktop/display-multiple-elements-with-SELECTEDVALUE/td-p/650754
Best Regards,
Vignesh M
If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)
v-yuta-msftCommunity Support
What's your requirement? If you want to concatenate the selectedvalues as a new number value, could you please clarify your logic?
Regards,
Jimmy Tao
I need this-
- v-yuta-msft
In this senario, you don't need to create any measure, just enable the interaction between table visual and slicer visual.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
