Can't enable See Records on anything

[KHorseman]

Has anyone figured out the basic requirements to get a visual to allow the See Records option? I have been through 10 pbix files and the See Records button is grayed out on every single visual I have. I can't figure out why. The dev blog entry gives absolutely zero useful information other than telling me where the button is, and the only other relevant hit I've found is another forum post here where the OP is told to go read that blog entry.

I finally got it to work once by dragging a column straight into the Value field on a bar chart and letting it auto-aggregate. Does See Records just not work with measures? Not even a simple count or sum measure? Surely that can't be it. Measures are the backbone of this platform. A feature that doesn't support measures would be utterly useless. Am I missing something here?

[Seth_C_Bauer · Accepted solution]

@KHorseman Not missing anything. From the tests I've done, it does not appear to work when measures are introduced into the visual.

[akruzel]

This is something that all my users are confused by as being able to drill to details is critical in any BI tool.  Inhibiting the functionality because a Measure which is a crucial functionality of Power BI makes no sense when I can create a Calculated Field in Excel, add it to a pivot table and drill down.  Please go to this link to vote to add.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15408432-see-records-feature-impr...

[KHorseman]

Man this has been sitting unfinished for so long I forgot it even existed. We got all kinds of promises of complete functionality last year and I haven't heard a word about this feature since that August release. I assume the developers have also forgotten this exists at this point.

[KHorseman]

FYI everyone, See Records is mostly an outdated plan at this point. The currently implemented drillthrough and keep all filters features work beautifully and are vastly superior to however we all thought See Records would work on measures, in my opinion. You can set up a page customized to what columns and formatting you want to show, rather than showing whole records without control. People are still kudo-ing my last post so I can only infer that they think my complaints from over a year ago are still valid. This should be a dead topic because if you're looking for See Records, you're looking for a feature by the wrong name at this point.

[peterh]

Does anyone know if this functionality is still being worked on? I have the August update and the See Records option is still grayed out. If this is functioning as intended, what's the criteria for a chart in order for See Records to work?

[mike_honey]

Just retested this with the Feb 2017 release of Power BI Desktop - it still shows the original, so-called functionality, which is practically useless.

[Seth_C_Bauer · Accepted solution]

@KHorseman Not missing anything. From the tests I've done, it does not appear to work when measures are introduced into the visual.

[KHorseman]

That's... baffling. OK, I guess I will just consider this feature still in-development and hope that they eventually complete it.

[Bjoern · Accepted solution]

@KHorseman

It will be fixed in the May update:

http://community.powerbi.com/t5/Desktop/April-Update-Not-able-to-enable-See-Records-or-synonyms/m-p/...