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 ,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to cengizhanarslan , stoic-harsh ,danextian  for sharing valuable insights.

 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community