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
Anonymous's avatar
Anonymous
Not applicable
10 years ago
Hi,
If your requirement is using the DAX formula u mentioned above, then
Try joining the Date field of your fact table, with date dimension.
Then perform the calculation. Let me know if it works.
shamsuddeenvp's avatar
shamsuddeenvp
Icon for Post Patron rankPost Patron
10 years ago

Thanks Anonymous and Sean for your inputs.

 

I need not to have a trend, just need to have a comparison with current value with the previous year. and shows the variance value. How to implement that in Power BI dekstop with the arrows (red or green) which changes dynamically based on the variance.

 

Below is 

I am trying to use the the KPI visual which is there in out of the box.

 

I have calculated a measure 

lastPeriodValArr:=CALCULATE(
COUNTROWS('Arrival')
,SAMEPERIODLASTYEAR('Date'[Date])
,AllExcept('Date', 'Date'[Date])
)

 

I have added Month_Name in trend.

 

Value: Current duration value

 

Target: Above measure

 

It looks fine (we need to select some year to claculate the previous year), Actually Dashboard shows all the values  (not filters any year) at load and this KPI shows error since user not selected any year or any filter which calculates lastyearperiodvalue.

 

Error: "SAMEPERIODLASTYEAR only works with contiguous date selection."

 

Br,

Shamsuddeen

    • 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...