Forum Discussion

nicanica07's avatar
nicanica07
Frequent Visitor
10 months ago

Help Adding a Concatenated Column to Matrix Visualization that Ignores Slicers

Hello, I am working with data similar to the Sample Superstore. I’ve built a PBI matrix (attached) with several slicers, e.g., Sub-category, Product Name, etc. Please see the screenshot.   I...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Super User
10 months ago

Hi, I am not sure if I understood your question correctly, but I tried to create a measure like below.

Please check the below picture and the attached pbix file.

 

 

All Sub Category list in the order: = 
VAR _orderid =
    SELECTEDVALUE ( Orders[Order ID] )
VAR _t =
    SUMMARIZE (
        FILTER ( ALL ( Orders ), Orders[Order ID] = _orderid ),
        Orders[Sub-Category]
    )
RETURN
    CONCATENATEX ( _t, Orders[Sub-Category], UNICHAR ( 10 ) )
  • nicanica07's avatar
    nicanica07
    Frequent Visitor
    10 months ago

    Thank you for taking the time to help me! This is not what I am looking for because the table shows duplicated orders instead of one order per row.