cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
prashant_ora
Helper II
Helper II

set default value of slicer

I have a slicer called country having different value and based on the user login i want to select any of the country in slicer.

e.g User1 is having country value USA and UK

and user2 is having country value India and Aus

 

Now when the user1 login into  power bi the slicer should show either USA or UK any value and same for user2 based on his data.

 

Please suggest how i can set the default value in slicer based on the user .

 

Thanks

6 REPLIES 6
v-chuncz-msft
Community Support
Community Support

@prashant_ora,

 

You may try a similar way as shown in link below.

https://community.powerbi.com/t5/Desktop/Default-Behavior-Date-Filter-to-Most-Recent/td-p/235337

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

This is not solving the problem. How can i attach the sample pbix file here to explain my issues.

@prashant_ora

Have you found any solution to this? I am having a similar issue.

No....

SivaMani
Memorable Member
Memorable Member

I'm not sure you can dynamically switch the default selection.

 

I can suggest you a workaround that will be helpful

 

If the number of users is 2(idle)

create 2 roles and assign to the users

 

If the number of users will change,

 

  • Create a calculated column using USERNAME() - In a new table
  • Create another column in the existing table and fill their email address based on the country
  • create a relationship between the above columns

Hope I made it clear!


Best Regards,
Siva Mani

  • Create a calculated column using USERNAME() - In a new table
  • Create another column in the existing table and fill their email address based on the country
    • created a new column called email and filled with country, now this table is having two column country and username and email.
  • create a relationship between the above columns
    • Relationship will be username in new table and username in the existing table?
    • but how that slicer will be selected with one value in case one user is having more than 2 country. This will work only if there is one user and one country.
  • In my case i am having one table is having country
  • other table is having user and country mapping
  • one table is having user and default country
  • Now my requirment is when i use country slicer, it should show all the country(that is done),but out of those country the default one should be selected which is avilable in my user and default country table. 
  • Please suggest.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors