Skip to main content
Microsoft Idea

Power BI

Needs Votes

Define default selection for a column in the model

Vote (193) Share
Marco Russo's profile image

Marco Russo on 21 Jul 2020 16:13:16

Create a property that defines the default selection for a column in a table. It is very needed in Calculation Groups, but all the tables/columns of a model could benefit.
If that column is not referenced in the report, it should be filtered by default.
Ideally, the default is defined by a DAX expression, so that it could be adapted to the user connected to a data model dynamically.
It is acceptable that there should be a single selection, it is not necessary to support multiple selections for this feature.
If a slicer is applied to a report, it should provide the default selection, even though the user can make a different choice. This is the only change required to the report user interface layer of Power BI.
This feature should be similar to the "default member" property in a multidimensional model.

Comments (13)
Marco Russo's profile image Profile Picture

Luis Quedas on 15 Aug 2020 11:38:58

RE: Define default selection for a column in the model

Agreed. Very useful...

Marco Russo's profile image Profile Picture

Mark Hayes on 15 Aug 2020 09:16:00

RE: Define default selection for a column in the model

Agreed. In particular needed for Time Intelligence.

Marco Russo's profile image Profile Picture

Tiago Rente on 15 Aug 2020 07:51:59

RE: Define default selection for a column in the model

Another interesting scenario, would be to a add a default member for a perspective and also for a role.