Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

KPI not Working

Hello,

 

I am using the KPI visual, but it is not working.

 

I have a measure that calculates the spending and another measure that is the goal of that spending.

 

When I use the cards, it shows the correct values for each measure, but when I put them in the KPI is does not show the correct data.

 

Not sure how to fix this.

 

Thanks!

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous, 

     

    I have struggled with KPI visual in the past. 

    What i found useful is as below (There are 100s way for doing the same)

     

    For Eg you have 2 measures

    MEASURE1 = Which calculates the spending

    MEASURE2 = Goal of that spending

     

    Create a new Measure and use DAX as below-

    IF(SELECTEDVALUE(Sample_Data[Measure1_Spending])<SELECTEDVALUE(Sample_Data[Measure2_Goal]),UNICHAR(9989), UNICHAR(9940))
     
    Instead of KPI Cards, Use Card Visuals and filter out whichever ID you wanna show.
     

     

    This gives more flexibility to maintain and show KPI's.

     
    If you find this helpful, please accept this as answer.
     
    Cheers,
    Namish B 
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      not quite, I would like to stick to the KPI visual, I need to show the information just as that visual lays it out.

       

      Please help.

       

      Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    It may be because you didn't sort by FiscalMonth. KPIs don't have a sort option. You'll need to start again and sort by FiscalMonth before you convert your visualization to a KPI.

     

    Reference: Create key performance indicator (KPI) visualizations

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.