Formatting Table Column to Display only first of Duplicate Values

[andynoodle]

Hello,

I am using a table in Power BI dekstop, and the data currently looks like this:

8/24/2017      Interview 1

8/24/2017      Interview 2

8/24/2017      Interview 3

8/24/2017      Interview 4

8/25/2017      Interview 1

8/25/2017      Interview 2

8/25/2017      Interview 3

And I would like it to look like this:

8/24/2017      Interview 1

                       Interview 2

                       Interview 3

                       Interview 4

8/25/2017      Interview 1

                       Interview 2

                       Interview 3

Is this  possible? Thanks! 

[v-caliao-msft · Accepted solution]

@andynoodle,

Please try to use a matrix visual, and trun off "Stepped layout" property.

Regards,

Charlie Liao

[SivaMani · Accepted solution]

@andynoodle

Try the Matrix visual.

[v-caliao-msft · Accepted solution]

@andynoodle,

Please try to use a matrix visual, and trun off "Stepped layout" property.

Regards,

Charlie Liao

[JTucker]

I am trying to do soemthig similar to create a BOM the data looks like this except with 4 attributes per level:

Assembly	Descr	Part A	Descr A	Part 1a	Descr 1A
Assembly	Descr	Part A	Descr A	Part 1b	Descr 1B	part 2a	Descr	part 3a	Descr
Assembly	Descr	Part A	Descr A	Part 1b	Descr 1B	part 2a	Descr	part 3b	Descr
Assembly	Descr	Part A	Descr A	Part 1b	Descr 1B	part 2b	Descr	part 3c	Descr
Assembly	Descr	Part B	Descr B

But I want to supress all repeated values like this:                                  

Assembly	Descr	Part A	Descr A	Part 1a	Descr 1A
				Part 1b	Descr 1C	part 2a	Descr	part 3a	Descr
								part 3b	Descr
						part 2b	Descr	part 3c	Descr
		Part B	Descr B

I tried to use a matrix but it will not display multiple attribute colums.  I can drill though the multiple levels, but only with a single attribute.  And if I add the first description, it won't display the Assembly code.  Is there not a simple Display First setting somewhere?  I have never seen a tool (and I have used just about all of them) that woin't allow you to group on a column (not Power BI grouping on values) and then either show all of them or just the first or last and/or merge the grouped cells.  

[zivhimmel]

Try changing from a table visual to a matrix visual and keep both fields on the rows.