Results 1 to 2 of 2

Thread: Dashboard shows every employee in history of company. 2 columns start and end date

  1. #1

    Dashboard shows every employee in history of company. 2 columns start and end date



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I´m new to this forum and powerpivot as well. I hope somebody can help me with my little powerpivot issue.

    I have a 4 different tables.

    The first one "Resource" includes 3 different columns, Name of employee, Employment Date & Termination Date.

    The second one "SP_Day" includes the columns, name of employee,activity date, hours of overtime.

    The third table contains name of employee, Job Description, Quantity.

    The last one is the calendar table.

    I created a dashboard which has two reports. The first one shows sickness absence rate for each employee and the second one the hours of overtime. The values of each report is fine. But my problem is, that they show each employee in the history of the company. I added a timeline slicer to show me just the employee for example at the end of 2017.

    Can anybody help me to solve my problem?

    I hope I explained clear enough the probleme I have. Sorry my bad explanaition and even worse english, I´m german.

    Thanks for every answer and help!

    Tendo

  2. #2
    Conjurer Ed Kelly's Avatar
    Join Date
    Jul 2016
    Posts
    162
    Articles
    0
    Excel Version
    2016
    Try to always supply a file when asking question. I am assuming that you are using an explicit rather than implicit measure, if that is the case check that the measure reads "Allselected" not "All", as "all" will over ride all slicers. If not the problem, consider sending the file with fictitious data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •