Forum Discussion

scabral's avatar
scabral
Helper IV
4 years ago
Solved

default slicer value

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...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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's avatar
amitchandak
Super User
4 years ago

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/