Forum Discussion

kprasad's avatar
kprasad
Frequent Visitor
9 years ago
Solved

KPI Visual does not work properly for new year dates.

Hi all,   I am working on a dashboard, in which I am trying to implement a KPI visual for current period vs previous period values. The visual works correct for the end date upto 31st December 2016...
Reports
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    kprasad

     

    That’s just how the KPI visual works. In your case, you can create following two measures to replace the Current sessions and Previous sessions.

     

    Current = 
CALCULATE ( SUM ( Test[Current sessions] ), ALLSELECTED ( Test[Date] ) )
    Previous = 
CALCULATE ( SUM ( Test[Previouse sessions] ), ALLSELECTED ( Test[Date] ) )

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

kprasad

 

That’s just how the KPI visual works. In your case, you can create following two measures to replace the Current sessions and Previous sessions.

 

Current = 
CALCULATE ( SUM ( Test[Current sessions] ), ALLSELECTED ( Test[Date] ) )
Previous = 
CALCULATE ( SUM ( Test[Previouse sessions] ), ALLSELECTED ( Test[Date] ) )

 

Best Regards,

Herbert

kprasad's avatar
kprasad
Frequent Visitor
9 years ago

v-haibl-msft,

Thank you,For your solution. This trick worked for me.

Best Regards,

Prasad.