Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
3 months ago
Solved

show multiple seletced values inside matrix visual

can it be possible to show multiple selected values in single cell of matrix visual as shown below considering there are two slicers one is for Region ( single select) and another is for category ( m...
Need Help
  • danextian's avatar
    danextian
    3 months ago

    Hi powerbiexpert22 

    You will need to concatenate the values either as a measure if you want the concatenated values to change dynamically  or as a calculated column if you want to use it as dimension

    Subcat Concat = 
CONCATENATEX (
    VALUES ( 'Product'[Subcategory] ),
    [Subcategory],
    UNICHAR ( 10 ),
    [Subcategory], ASC
)

     

     

v-anbandari's avatar
v-anbandari
Community Support
3 months ago

Hi powerbiexpert22 ,

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

 

Thank you.