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 ( multiselect)?

 

 

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
)

     

     

5 Replies

  • danextian's avatar
    danextian
    Super User
    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
)

     

     

  • stoic-harsh's avatar
    stoic-harsh
    Super User
    3 months ago

    Hey powerbiexpert22,

    danextian gave a good approach. A few suggestions:

    1. The original question had a region slicer too. Below measure covers both in matrix cell.

    2. ISFILTERED() provides a clean fallback of "All Categories" (production-grade DAX), when no category is selected. Remove if not required.

    3. Ensure Word Wrap is enabled. Without this, the UNICHAR(10) line breaks are invisible and everything appears squished on one line.

    Selected Info =
VAR SelectedRegion = SELECTEDVALUE( Sales[Region], "All Regions" )
VAR SelectedCategories =
    IF(
        ISFILTERED( Sales[Category] ),
        CONCATENATEX( VALUES( Sales[Category] ), Sales[Category], UNICHAR(10), Sales[Category], ASC),
        "All Categories"
    )
RETURN SelectedRegion & UNICHAR(10) & SelectedCategories

    Best,

    Harshit

  • cengizhanarslan's avatar
    cengizhanarslan
    Super User
    3 months ago

    Please try the measure below:

    Selected Categories =
CONCATENATEX (
    VALUES ( 'Table'[Category] ),
    'Table'[Category],
    ", "
)
  • 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

  • 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.