Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

KPI Visualization - Using LY's Monthly Sales as Goal for TY's Monthly Sales

Hi All!   I am relatively new to Power Bi and am creating a dashboard for our Inside Sales Team. I am trying to create a KPI of Monthly Sales Totals and the goal being last year's monthly sales +15...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous

     

    • Create a Slicer on Sales Months
    • Place the Sales Measures  Sales = SUM(Sales_Fact[Sales_Amt]) in the "Indicator" field in the Field tab
    • Place the Months in "Trend Axis" field in the field tab. Please make sure the Month name is sorted using the Month number.
    • Create Target Sales Measure  LYSales Target = CALCULATE(SUM(Sales_Fact.Sales_Amt),DATEADD(Dates[Date],-1,YEAR)) * 1.15 and place this measure in the "Target goals" field in the field tab

    Your KPI visual will be ready to use now. Hope this helps.

     

    Thanks
    Raj

     

     

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

Could you please offer some sample data and post your desired result if possile?

 

Regards,

Daniel He