Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

KPI shows wrong value

Hello,

 

I am creating a KPI but it only captures the number of the last month.

First, I have created a Column Chart Axis - Month (from Sort-Month tbl), Values - New Employee ( from Employee tbl) and then I sorted it out by Month. The column chart shows the correct values per month from Jan to Dec. Then I clicked on the KPI and the value shows 14 which is the value from Dec. only and should be 184 from Jan to Dec. The indicator New Employee is already in SUM.

 

I've already followed the tutorial here but my problem is that it's showing a wrong value in the KPI

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

1 ACCEPTED SOLUTION

Hi,

I think this is what you want.  Download the PBI file from here.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

10 REPLIES 10
Ashish_Mathur
Super User
Super User

Hi,

Share the download link of your PBI file and show the problem very clearly.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Hi,

I think this is what you want.  Download the PBI file from here.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Thank you @Ashish_Mathur for the measure you created. I've learned another technique. Thank you so much.

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Apologies for not being clear, I mean the green background image if the goal has been reached or the red one if it didn't 🙂

 

Mish101_0-1613008076560.png

 

Sorry i would not be able to help with that.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

it's okay. Thank you @Ashish_Mathur !

Anonymous
Not applicable

Hello @Ashish_Mathur ,

 

I have applied your solution in my dashboard. I just have a question, do you have any idea on why the trend axis is not showing? I turned it off and on a few times but it's still not showing. Thank you 🙂

Not sure what you mean by that.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.