Reply
Super User
Posts: 1,183
Registered: ‎12-29-2015
Accepted Solution

Can't enable See Records on anything

[ Edited ]

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?


Accepted Solutions
Super User
Posts: 3,484
Registered: ‎06-25-2015

Re: Can't enable See Records on anything

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

Near SE WI? Join our PUG MSBIWI

View solution in original post

Established Member
Posts: 129
Registered: ‎07-14-2015

Re: Can't enable See Records on anything

[ Edited ]

All Replies
Super User
Posts: 3,484
Registered: ‎06-25-2015

Re: Can't enable See Records on anything

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

Near SE WI? Join our PUG MSBIWI
Super User
Posts: 1,183
Registered: ‎12-29-2015

Re: Can't enable See Records on anything

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

Established Member
Posts: 129
Registered: ‎07-14-2015

Re: Can't enable See Records on anything

[ Edited ]
Frequent Visitor
Posts: 2
Registered: ‎09-30-2016

Re: Can't enable See Records on anything

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?

Advisor
Posts: 281
Registered: ‎06-28-2015

Re: Can't enable See Records on anything

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

Regular Visitor
Posts: 22
Registered: ‎08-04-2016

Re: Can't enable See Records on anything

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...

Super User
Posts: 1,183
Registered: ‎12-29-2015

Re: Can't enable See Records on anything

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.

Highlighted
Super User
Posts: 1,183
Registered: ‎12-29-2015

Re: Can't enable See Records on anything

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.