Forum Discussion
powerbiexpert22
Impactful Individual
Impactful Individualshow 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...
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 )
cengizhanarslan
Super User
Super UserPlease try the measure below:
Selected Categories =
CONCATENATEX (
VALUES ( 'Table'[Category] ),
'Table'[Category],
", "
)