Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Auto-Select Slicer Value

I have a table that contains a list of people similar to below:

NameEmail
Sally Jones[email protected]
Ed Smith[email protected]
Jose Perez[email protected]
Juanita Clark[email protected]
Karen Falk[email protected]
Marcel Thompson[email protected]
Alan Ames[email protected]

 

I have a slicer (drop down) visual that I can use to show the list of people (Sally, Ed, Jose, etc.) and what I'd like to do is have the slicer (when report is accessed/loaded) change to who ever is accessing it but still allow the ability to select another person if need be.  So for instance if Karen is accessing the report the drop down will automatically show her name however if she wanted to look at the information for another associate, she could click the drop down arrow and select anyone else she wants (Alan, Marcel, Juanita, etc.)

 

I was able to determine who is logged in/accessing the report by using the following dax ( loggedIn = USERPRINCIPALNAME() ), however I haven't been able to find anything that would allow me to be able to automatically select the userprincipalname for the slicer.  For instance when Jose loads the report, loggedIn shows [email protected] and I can't figure out how to make the slicer changed from the first value in the table ([email protected]) to my variable (loggedIn).  Does anyone know if this is possible or a work around that could accomplish what I'm looking to do?  Any / all help that can be provided would be much appreciated, thanks.

 

Regards,

Cody

default slicer value
selected value
Slicer

2 Replies

  • ribisht17's avatar
    ribisht17
    Super User
    4 years ago

    Anonymous 

     

    USERNAME /USERPRINCIPAL will always have the user name of the person logged in.

    I don't think this can be handled by DAX.

    There is a possibility for an Admin to switch over to other roles (as you can do in Tableau) but not with this Table approach

     

    Regards,

    Ritesh

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Ritesh,

       

      I think I understand what you're saying, let me ask this...  Is it possible to filter a table by correlating the userprincialname to a value in the table?  So for instance I have this measure:

      actingsupervisor = IF(
           CALCULATE(
                HASONEVALUE(FTEs[name of supervisor]), ALLSELECTED(FTEs[employee])) = TRUE(),1,2)

       

      I then put this measure as a filter on the visual and use it to show items when the value is 1.  This will allow me to display only the employees related to that supervisor in the visual that his this filter.  So is it possible to replace the 'FTEs[name of supervisor]' of the measure above with something like userprincipalname()?