Hiding values in a table column

[tomgramling]

Hi,

I have a table that looks like this.

column1  column2

NE            A

NE            B

NE            C

SE             D

NW          E

NW          F

I want to hide the duplicate values in column1 so my table looks like this

column1  column2

NE           A

               B

               C

SE           D

NW         E

               F

Is this possible?

Thanks,

Tom

[v-lili6-msft]

hi @tomgramling 

You could use matrix visual as below:

Note: Disable Stepped layout in Format-> Row headers

Regards,

Lin

[tomgramling]

I need it to remain as a table for some other reasons. A matrix won't work in this instance.

[v-lili6-msft]

hi @tomgramling 

To my knowledge, it could not achieve in table visual in power bi for now,.

Regards,

Lin

[PBIfanatic]

Hi @tomgramling ,

You can use the matrix visual to achieve something similar.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual