Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Target Value settings

  • 1.  Target Value settings

    Posted 26 days ago
      |   view attached
    Team,

    Please look into attached document and advise how can set target value aganist an employee..

    ------------------------------
    Unais T K
    DC ADministrator
    ------------------------------

    Attachment(s)

    docx
    targetvalue.docx   209K 1 version
    Conference-PBI_200x200


  • 2.  RE: Target Value settings

    Top Contributor
    Posted 26 days ago
    Hi Unais !

    You need to connect your EMP_Target table to Date dimension table as well so targets will be loaded based on date criteria

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------

    Conference-PBI_200x200


  • 3.  RE: Target Value settings

    Posted 25 days ago
    Hi Hashim,

    thanks for update..

    i have invoice header table and invoice line item table.. invoice header table having finanancial year and invoice line item table having sales mana aganist each item sales.. target is based on financial year and sales man in target table.. if i made relation with invoice line item aganist sales man but while adding target am not getting filter by finanacial year its showing total of target aganist sales man..

    ------------------------------
    Unais T K
    DC ADministrator
    ------------------------------

    Conference-PBI_200x200