Issue with data show in table visualization

[asif082]

Hi,

Can some one please help me with this. I have a very simple data with unique ID but I don't want ID to show in table visualization but as soon as I uncheck ID its group Lead Professional please see below.. 

Thank you so much.

NOTE: Data is quite comprensive and I have extracted an example here.

Data

[v-yuta-msft]

Hi asif082,

Rows will be merged in one row if all values are same in table chart, you should keep the ID column in your table chart.

Regards,

Jimmy Tao

[Phil_Seamark · Accepted solution]

Hi @asif082

The table visual, by nature will group columns together.  If you want to overrule this, one idea is to keep your ID column in the table but set the font colour and background colour to the same value (white?) and maybe make the column width smaller.