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

[Anonymous]

Hi,

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

Eg:

Rows	Col1	Col2	TS
A	1	2	Wk1
A	3	4	Wk2
B	11	12	Wk1
C	21	22	Wk1
D	31	32	Wk1
E	41	42	Wk1
E	44	45	Wk2

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

[V-lianl-msft]

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]

Hey @V-lianl-msft ,

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

Regards,

[MFelix]

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]

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 · Accepted solution]

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

[Anonymous]

Hey @MFelix ,

This was a good workaround. Have implemented that on my visual. Works fine

[MFelix]

Hi @Anonymous ,

Forgot to mention that if you will present as a table visual you can also turn off the visual headers so that people don't have the option of making the drill up drill down.

Regards,

MFelix