Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
7 years ago
Solved

KPI Displaying incorrect Indicator

IM really confusd about the KPI

 

I create a Gague Sales Amount in Value. Target is 70 Million. 

This comes up fine showing Sales Amount as 83 Million (everything)

I then create a KPI

Sales Amount in Indicator

Trend contains Month Date of Sale (Dragged infrom the date hierarchy)

Target goals contains the 70 Million 

 

However the KPI only shows 7 Million. Ive no idea where its getting that number from. Its not even a figure in any of the years worth of data.

 

Can anyone advise on this? Thanks in advance

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I suggest that you create a table visual beside your KPI, then drag all the attributes that you have in the KPI visual into the table visual. Then you should be able to see what is happening. The KPI visual can be set up in many different ways, sortet, etc.

     

    Hope this helps.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Is it possible that it is the total sale for the last month in the KPI? If you have month as the trend then your target must be sales per month, just a thought?

    • DebbieE's avatar
      DebbieE
      Community Champion
      7 years ago

      I thought trend was just for the chart behind the actual indicator.

       

      The last months comes to 3.4 M so this doesnt work

       

      I tried changing the trend to Year but then I get nothing for my indicator which is increcibly confusing

       

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi DebbieE,

     

    If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best  Regards,

    Cherry

    • DebbieE's avatar
      DebbieE
      Community Champion
      7 years ago

      Its just Adventureworks linked from FactResellerSales and DimDate

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I suggest that you create a table visual beside your KPI, then drag all the attributes that you have in the KPI visual into the table visual. Then you should be able to see what is happening. The KPI visual can be set up in many different ways, sortet, etc.

         

        Hope this helps.