default slicer value

[scabral]

Is there a way with Power BI to default a slicer value from a disconnected table based on another table field?

for example i have a table called Client with AcctNumber and Classification.  I have a disconnected table with also AcctNumber and Classification.   The reason for the disconnected table is to bybass Role Based Security for aggregated values.

If a user opens the report, i am passing the AcctNumber from the Client table as a filter.  What i want to do is default the Classification from the disonnected table to the Classification for the AcctNumber from the Client Table.

[v-xiaotang · Accepted solution]

Hi @scabral 

It is not supported to default slicer, as a workaround, you can create a measure to get the value from slicer or to get the value from another disconnected table. 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@scabral , A table can be defaulted using a a column value ,

So you can have a new column like

If([AcctNumber] =max(roller[AcctNumber], "Current User", [AcctNumber])

Then you can select the current user.

As of now, the function is not supported to set default values in slicers.

You can vote for an idea or log new one https://ideas.powerbi.com/ideas/