Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to show multiple line items for same row in matrix visual

Hi,

 

I am looking for a matrix like visual which could show multiple rows for one type of line item.

Eg:

 

RowsCol1Col2TS
A12Wk1
A34Wk2
B1112Wk1
C2122Wk1
D3132Wk1
E4142Wk1
E4445Wk2

 

Lets say I am putting the rows column in the rows of a matrix and col1 and col2 in values/columns. My TS column would be going in the filter pane.

Now, if I select Wk1 from the filter, it'll give me all the results for Wk1.

if my filter pane is multi-select and I can select Wk1 and Wk2 at the same time, the matrix visual will not show 2 rows for A and E and would only give the first row as result. (either one from Wk1 or Wk2)

What I am looking for is multiple line items for same row should be coming if I am doing multi-selection from filter pane.

 

I tried adding TS to the visual and hiding it but it doesn't look good. Also, I am okay if there's any other visual that I can import from the marketplace.

 

Thanks,

parry2k , Cmcmahan

  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    Being your values calculated as measures you don't have the option don't summarize, what you can do to work around that can be create a new column with the [Rows] and [TS] values togethers then use that as your first value on the rows, drill down to the latest level, turn off word wrap and hide that column check the image below:

     

     

    It's a poor workaround but can be an option, based no the low level of information are showing.

     

    Regards,

    MFelix

7 Replies

  • Hi @RohanChhabtra,

    On the values columns choose the don't summarize optio that will return all the values for the selected columns, then based on the filter the information will have several results.

    Regards,
    MFelix
    • Anonymous's avatar
      Anonymous
      Not applicable

      Hey MFelix ,

       

      I don't see any such option as don't summarise in the values. Basically these columns are measures created and called in as values.

      Can you please elaborate a bit more as of where can I find the option

       

      Regards,

       

      • MFelix's avatar
        MFelix
        Super User

        Hi Anonymous ,

         

        Being your values calculated as measures you don't have the option don't summarize, what you can do to work around that can be create a new column with the [Rows] and [TS] values togethers then use that as your first value on the rows, drill down to the latest level, turn off word wrap and hide that column check the image below:

         

         

        It's a poor workaround but can be an option, based no the low level of information are showing.

         

        Regards,

        MFelix

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    Hi Anonymous ,
     
    Based on your requirements, you can use table visual.
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • Anonymous's avatar
      Anonymous
      Not applicable

      Hey V-lianl-msft ,

       

      I tried that option but my format/style of data changes which I am not looking for 😞

       

      Regards,