"See records" displays lots of columns

[CloudMonkey]

Hi,

I am using a calculated field in a matrix preview, with the "See records" option enabled. When the user right clicks on a number and selects "See records" then they are taken to the underlaying data which consists of all columns present in the table that the calculated field is held in, as well as columns from other tables that are used in the field's DAX formula. I'm getting way to many columns (about 50) which is overwhelming the user - please can you tell me how to reduce the number of columns visible when a user chooses to "See records"?

Thanks,

CM

[CloudMonkey · Accepted solution]

Ahh found it, the columns showing in the "See records" drilldown can be removed in the same way normal visualation rows / columns can be added/removed. So just click on the "x" to remove a column

[mhambalek]

But is there a way to have those columns 'stick' so that when the user does a See Records again they see the same columns? I don't want to have he user continually remove columns each time they See Records.

[CloudMonkey]

Hi @mhambalekI think the matrix preview has been removed from the latest Power BI release and the standard matrix does not allow "See Records" so I think you question is no longer relevent?