HELP Please: Show the Data But Not All the Details (Data Filtering Based on USERPRINCIPALNAME?)
Hello, I have a table that shows production and I would like all employees to see everyone's production but only see their own name (the rest of the names should be blank). This I have achieved using this DAX below. However, if the user logged in is a supervisor (the Employees table has a Supervisor column with a Yes or No value), there should be no filters and he/she should see all data. In the screenshot below, if Princess Leia is a supervisor, she should see all the Employee Names. Also, the supervisor may or may not have production numbers in the table. Any suggestions for how to do this? I would appreciate any help please. EmployeeName = IF( SUM('Production'[Quantity]) && SELECTEDVALUE('Employees'[LogInEmail])=USERPRINCIPALNAME(), SELECTEDVALUE('Employees'[Name]) ) Here's how it looks - Darth Vader is the user currently logged in. After I took this screenshot, I made Darth Vader a Supervisor and I want all the Employee Names to display instead of just his own name. Data tables: Employees: Production: I thought about maybe having a separate Supervisor table that contains a list of supervisors? Thanks in advance!
Date Range based on Slicer selection
Hello - I'm looking to return a list of the previous "X" days based on a selected day from a slicer. For example, once a day is selected in the 'Date' slicer, I want to return the date range in the visualization for the previous 180 days up to the selected day. In simple words, the logic would be something like the below, but I cannot make it work: IF ( Date >= SELECTEDVALUE ( Date )-180 || Date <= SELECTEDVALUE ( Date ) , Date , blank() ) And then use 'Date' in the visualization and exclude blanks. Any recommendation is more than welcome, thanks!!
