cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
franorio Member
Member

KPI question

Hello everybody,
first of all my PowerBI knowledge is very basic, so i guess this should be piece of cake for you.
 
I need to create a KPI able to show the vacancy fulfillment, this should be the% of Quantity of closed position in target / Quantity of position.
I have done that, and it looks like this ... in some cases does the job, in others (when apllying a filter, it doesn't)

43/49 = 0.88 -> great
2/3 = 0.67 -> great
18/18 = 1 -> great
695/749 = 5 -> ???
20/20 = 2 -> ???
271/297 = 5 -> ???

Don't understand why it works in some cases and in some other don't.

Appreciate your help and input on this matter.

 

Best regards!

 

 

KPI.jpg

 

 

 

3 REPLIES 3
Super User IV
Super User IV

Re: KPI question

Seems like you are using value in Trend Axis in KPI's which have the issue. Once you have added column in Trend Axis, your KPI calculation will be based on that field, without knowing the data and your values, very hard to tell what could be the other reason. I would recommend try without trend axis and see if you get the results.

 

Thanks,

P






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





franorio Member
Member

Re: KPI question

Thanks for your reply P!!

What i need is to create a KPI that shows the vacancy fulfillment of the company. This means i need to calculate 

 

Quantity of positions closed in time divided quantity of total positions

 

for example the company is looking to fulfill 300 positions in certain frame of time (60 days is the target established), of those 300 position, only 290 were fulfill in time, so the kpi should be 290/300 = 97%

 

tried out with the gauge but don't know how to show it on %, without changing all my values on the columns.

 

Any advice? Really appreciate your help

Thanks!

 

Microsoft v-ljerr-msft
Microsoft

Re: KPI question

Hi @franorio,


tried out with the gauge but don't know how to show it on %, without changing all my values on the columns.


There is a DiaGague custom visual on Power BI Visual Gallery. Could you go to check if it helps in your scenario?Smiley Happy

 

Regards

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors