Skip to main content

Power BI

Needs Votes

detail row expression

Vote (75) Share
Johan Tysklind's profile image

Johan Tysklind on 22 Feb 2017 03:26:27

The new SSAS Tabular will support detail row expressions. It would be great if "See Records" would support that as well. So that the drill through data set can be defined in the tabular model.

Comments (5)
Johan Tysklind's profile image Profile Picture

Rebecca Gigliotti on 19 Jun 2023 18:39:27

RE: detail row expression

This would be a very helpful addition in PowerBI.We are using the drill through functionality as a workaround but that doesn't work well with Object Level Security. If there is a field on the drill through page that is available to some users, but not others, you would essentially have to build two versions of the same report. If a user doesn't have access to a field in the drill through the entire page will throw an error if there is no access to a field instead of handling it properly the way Excel or the DAX DETAILROWS function would.

Johan Tysklind's profile image Profile Picture

Power BI User on 05 Jul 2020 23:45:20

RE: detail row expression

This feature is available in Excel. Take the Excel team out for a crumpet or a stack of pancakes and pick their brain on some VSS code you can "borrow". :D

Johan Tysklind's profile image Profile Picture

Em172967 on 05 Jul 2020 23:34:00

RE: detail row expression

Please add this. Most important .issing feature in my opinion. Can't believe there isn't more upvotes.

Johan Tysklind's profile image Profile Picture

Jian Zhou (Miracle) on 05 Jul 2020 23:22:31

RE: detail row expression

It is a very intuitive thing to do. Unfortunately it is not the case in Power BI. Product team, please utilize this new function DETAILROWS.

Johan Tysklind's profile image Profile Picture

Marco Angelini on 05 Jul 2020 23:06:06

RE: detail row expression

This is a very good idea, with this I use PowerBI on my DNR credit risk reporting tool used by 1.350 Unicredit Italy colleagues at the moment.