1. Be used with all types of visuals (charts, tables, matrix, custom visuals)
2. Compatible with Calculated measures
3. Allow for feature to be turned on or off for each individual visual
Would also propose a variant of #3. Allow a limit to be set for the number of records that can be viewed. In many cases allowing someone to view or copy the entire dataset has to be prevented but not necessarily allowing someone to view or copy a few individual records. So configuration functionality to allow users to drill down and see a few records while restricting bulk record viewing would be helpful.
I desperately need this feature to be fixed. This is pretty ridiculous to have to edit the See Records every single time I need to see a date column.
All of a sudden every dimension I have comes across in the See Records and the assistance I got from the help desk was to un-click the fields .... that defeats the purpose for the business users .... there needs to be a way to setup the desired number of columns during the setup of the dashboard. PLEASE!
Not only has it been requested for over 2 years, it looks like PowerBI team hasn't even acknowledged the need of this. Ridiculous. There HAS to be a way to save the setup of desired columns so that you don't have to manually arrange it everytime you come back to See records.
No word from Microsoft on this basic functionality?
I can see the validity of all three but #2 may be a deal breaker for me. Seems like this would be a basic capability since it is already included in PowerPivot. Unfortunately I may have to switch my reporting to Tableau because of this issue.
Definately required. As it currently stands "See Records" seems great, but you soon find out how incomplete the implementation is.
As well as hiding, moving column, the ability to add columns from the same table(s) used in the visual is a requirement. For example I have a table with a measure based on a date field, but I can't see the date field in "See Records". Go figure!
Related Idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15090138-see-records-column-setup
As pointed out in a post on the community forum, you can exploit this flaw to see the names of individuals in an otherwise anonymous chart. There's even an example *promoted by Microsoft's own BI blog* showing charity beneficiaries on the chart 'number of projects by area', here:
This needs a fix!
Number three would be particularly valuable. I work in a public agency with highly sensitive data - not being able to turn it off really limits how widely I can share.