When I right-click on a visualization report, I get the "see records" option, I click on it, and I get the right number of records but a column that I'd like displayed as well, is not showing, I can add it while being in the "see records" section, but once I click on "back to report", then it's gone.
I reviewed the table's definition and it's including it. How can I add a column in that section and make it stay? where is the "see records" setup?
Thanks a lot!
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
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.
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.
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 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."
We are also needing this feature. We'd like to configure the columns, column order, and custom titles for "View Records", and then have that persisted when it is viewed later. Currently, it looks like this has to be manually set each time the record data is viewed from a report.
This is ridiculous - whoever put this together should be fired - they left an incomplete/in properly implemented feature go into production. Christ -- didn't they even test this out?
Is this a feature add I can vote for? It's a complaint I get from my end users that the records aren't helpful as they have to weed through the junk columns. I added some to the tool tips but if you get too many the hover pop up becomes usless.
This feature is very needed. The end users need to resolve scenarios where records don't meet certain criteria. Hitting them with every value in the dataset is not efficient. Hopefully this is coming soon!
I'm having the same issue. Can't get the See Records to show only the columns I want. After I rearrange in the See Records view, then click out and back in, the columns are not saved.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.