How to remove total/max/min, etc. on SPECIFIC column of Matrix Table?

[chaichatp]

I tried to find the"Don't Summarize" opion on Values but there is no that option unlike normal Table. Any ideas? Thanks.

[v-frfei-msft]

Hi @chaichatp,

"Don't Summarize" opion is not supported in Matrix, However we can add an index column to work around.

For more details, please check the pbix as attached.

Regards,

Frank

[chaichatp]

Interesting. The reason why i use matrix is because i can freeze the first column which I cannot do on normal table. 😞 If you have any ideas to freeze column for normal table, i would appreciate. Thanks.

[Anonymous]

You can, you simply need to include the field in the "Rows" section.  Values is where you place anything you want aggregated. 

[chaichatp]

Could you please show me an example? Thank you.