Forum Discussion

Yash_'s avatar
Yash_
Regular Visitor
4 years ago
Solved

Power BI Slicer default value as per UserPrincipalName

I'm trying to create a slicer which will contain the names of the users. The table which contains usernames also have a column email_id, which will contain userprincipalname of the user. How can I cr...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Yash_ ,

     

    Create a measure like below:

    Measure = IF(SELECTEDVALUE('Table'[email_id])=USERPRINCIPALNAME(),1,0)
    Then add this measure to visual filter and set value = 1.
    After that the visual will only show the data that matched the user and users could see all data if they clear the filter.
     
    Best Regards,
    Jay
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Yash_ ,

 

Create a measure like below:

Measure = IF(SELECTEDVALUE('Table'[email_id])=USERPRINCIPALNAME(),1,0)
Then add this measure to visual filter and set value = 1.
After that the visual will only show the data that matched the user and users could see all data if they clear the filter.
 
Best Regards,
Jay
  • Nivedhana's avatar
    Nivedhana
    Icon for Helper I rankHelper I
    3 years ago

    Very helpful! Is there a way we can select this slicer value by default?