Agree whole heartedly. It has been proposed several times as an idea, https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15408432-see-records-feature-impr... has gained the most traction.
As it stands it looks like a half completed feature that was put into production to cross it off a feature requirement list.
I was searching for the same solution. My users need to be able to view the entire record as well. I can configure which columns to show, but there doesn't seem to be a way to save the columns selected when you return to the visualization. I'm trying to move them away from giant printed spreadsheets on 11x17 paper, but can't do it if they can't see the details behind the "pretty graph."
Really want this feature.
My work around is to create a simple visualization that uses a calculated field that adds up all the values you want included. Then you can see records on that 'box' / button.
Agree no fix for two years is terribly frustrating. The workaround I have used is to edit the query by duplicating the column(s) you want to make visible in See Records, and then change the type of the duplicate column to text. That has worked for me.
Terribly frustrating that Microsoft hasn't yet fixed. The workaround I have used is to edit the query by duplicating the column(s), change the type of the duplicate to text and then reorder as needed. This has worked for me.
There's still no fix. I discovered recently that you may be able to use a drill through page as a work around for this in some situations. At least in a matrix filters for the cell you are on are passed through to the drill through page. You can setup a table on that page with whichever columns you want to have visible