Define default selection for a column in the model

[marco4]

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.

[Keith_Dunn]

Absolutely right on the mark. Easily the most frustrating limitation of tabular cubes, especially when working with time intelligence and period calculations. This is the one hole I have found in tabular that I just can't work around.

[juerg_jenny2]

very much needed

[katrin_roeder]

I would really need this options

[fbcideas_migusr]

Missing this feature a lot.

In the OLAP cubes we have, a script is running at time of update, to default the date-dimension to yesterday. This making all time-intelligence measure work without having to select the next date manually in all reports.

[vtebus]

I cannot believe this is raised in 2020 still not implemented! Absolute must and one of the misses that makes Tabular and DAX adoption really painful. There should be the way to preset a default filter on any table in a semantic model, and for Calculation Groups this is close to the must.

[vtebus]

Just wanted to add - with the advent of Q&A and Copilot this even more critical as people are now interacting with data in many cases without a report: Copilot would run a DAX statement of the model without knowing that certain tables (calculation groups, first of all) do not make sense at the aggregated level and need to be filtered, it will give back a meaningless answer adding up the amounts in different currencies or actual + budget etc. Please add this feature!