Auto-Select Slicer Value
I have a table that contains a list of people similar to below: Name Email 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
Select current date as default selection in slicers. (Tabular model - Report Server)
Hello, So I have a 'Year' slicer and a 'Month' slicer, I want my end-users to enter the report with the current Year and Month selected. How to achieve this? I know its possible in Power BI desktop but notice that I am having this problem with Tabular model + Report Server. Thanks in advance, Jim