Bangalore Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

View My Drafts

Back to discussions
Expand all | Collapse all

Adding Average line of top 3 items to a line chart

  • 1.  Adding Average line of top 3 items to a line chart

    Posted May 24, 2022 05:40 AM

    I want to add average line of top 3 persons in the given line graph in Power BI also want to show each dates in Y-axis instead of 3.

    The needed graph has been created in excel as attached below (2nd picture). How can we do the same in Power BI? Please help me on this

    Post image

    Performance chart in Power BI

    Post image

    Performance chart in Excel

    Data is just three columns : Date, Name and Count of activities



    ------------------------------
    Fahim Ahamad
    Data Analyst
    ------------------------------