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 (14)
RE: Define default selection for a column in the model
How to vote it? Cannot find a way
F
RE: Define default selection for a column in the model
Agreed. Very useful...
RE: Define default selection for a column in the model
Agreed. In particular needed for Time Intelligence.
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.