Hiding values in a table column

Question

Hi,&nbsp;I have a table that looks like this.column1&nbsp; column2NE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ANE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BNE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CSE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DNW&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENW&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; F&nbsp;I want to hide the duplicate values in column1 so my table looks like thiscolumn1&nbsp; column2NE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CSE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DNW&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F&nbsp;Is this possible?&nbsp;Thanks,Tom

pbifanatic · Answer

Hi&nbsp;tomgramling&nbsp;,&nbsp;You can use the matrix visual to achieve something similar.https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

v-lili6-msft · Answer

hi&nbsp;tomgramling&nbsp;
You could use matrix visual as below:
Note: Disable Stepped layout in Format-&gt; Row headers

&nbsp;
Regards,
Lin

tomgramling · Answer

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

v-lili6-msft · Answer

hi tomgramling&nbsp;
To my knowledge, it could not achieve in table visual in power bi for now,.
&nbsp;
Regards,
Lin

Forum Discussion

Hiding values in a table column

4 Replies

Related content

PowerBI - Matrix table, hide values used only for a visual calculation

Matrix table column Hide

Splitting Column values

Hide column with blank values in matrix

hiding columns in Matrix