Forum Discussion

shamsuddeenvp's avatar
shamsuddeenvp
Icon for Post Patron rankPost Patron
10 years ago

KPI visual in Power BI

Dear,   I need to have a KPI, which shows sales comparing to the previous year for all the filter selection.   I created a measure using SAMEPERIODLASTYEAR function, however it doesnt work proper...
Need Help
shamsuddeenvp's avatar
shamsuddeenvp
Icon for Post Patron rankPost Patron
10 years ago

Thanks Sean

 

Yes, I need to show the trend by month. still I need to keep year in trend field?

 

Actually my requirement is that I need to show a trend graph in a way that what is the total sales this month and compare the value with previous year same perid sales.

 

Other screenshot you mentioned also useful for my requirement to show all the months variance between current value and previous year value in table format, however that would need to create KPI in powerpivot or in SSAS tabular model right?

 

Thanks!

Shamsuddeen

 

 

 

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

shamsuddeenvp Yes to both quesitions.

 

I would consider using a different visual - you don't have that much flexibility with the built in KPI

 

Look the charts look the same shape but the PBI built-in KPI will give you pretty much no details...

 

  • shamsuddeenvp's avatar
    shamsuddeenvp
    Icon for Post Patron rankPost Patron
    10 years ago

    Thanks Sean

     

    Please let me know if there is any feasibility to have a green Top directed arrow (Image) and red downward arrow to show whether the value is growing or shrinking. This image dynamically should change based on the variance value.

     

    Br,

    SHamsuddeen