Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
andynoodle
Regular Visitor

Formatting Table Column to Display only first of Duplicate Values

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! 

2 ACCEPTED SOLUTIONS
v-caliao-msft
Employee
Employee

@andynoodle,

 

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

 

Regards,

Charlie Liao

View solution in original post

SivaMani
Resident Rockstar
Resident Rockstar

@andynoodle

 

Try the Matrix visual.

 

Formatting Table Column.gif

View solution in original post

4 REPLIES 4
SivaMani
Resident Rockstar
Resident Rockstar

@andynoodle

 

Try the Matrix visual.

 

Formatting Table Column.gif

v-caliao-msft
Employee
Employee

@andynoodle,

 

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

 

Regards,

Charlie Liao

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

 

AssemblyDescrPart ADescr APart 1aDescr 1A    
AssemblyDescrPart ADescr APart 1bDescr 1Bpart 2aDescrpart 3aDescr
AssemblyDescrPart ADescr APart 1bDescr 1Bpart 2aDescrpart 3bDescr
AssemblyDescrPart ADescr APart 1bDescr 1Bpart 2bDescrpart 3cDescr
AssemblyDescrPart BDescr B      


But I want to supress all repeated values like this:                                  

 

AssemblyDescrPart ADescr APart 1aDescr 1A    
    Part 1bDescr 1Cpart 2aDescrpart 3aDescr
        part 3bDescr
      part 2bDescrpart 3cDescr
  Part BDescr 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
Resolver I
Resolver I

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.