This is a great video Jason....Thank you. I just need to ask two questions please: 1) If I want to add the YTD value , Rating scores from 1-5 for every KPI and an Overall rating scores for all KPIs, could you please show me the steps on how to add these? 2)How to link the date with these values? because when i tried to select different dates the values are gone.
Please help: My KPI Status shows up as a black + or - %. It doesn’t show the symbols or color even though I’ve added the KPI Indicator column. Not sure what I’m missing.
Hi this is really good video I have a question When you use var for kpi index, you don’t have to type measure but Var needs measure How do you solve this problem? Thanks
Hi Jason. This is great. We're now using this as well as the Risk Matrix from your previous video. The only thing that's irritating me about the Power KPI Matrix is the row heights seem to have a mind of their own and I can't find a way of controlling them. (Also is that an Aberdeen accent?)
Hi Martin, Thanks for the comment. It's great you've found this stuff usefull! I've never had an issue with the row heights but I feel your pain, sometimes things happen that you just can't figure out.🙄. It sure is an Aberdeen accent. Have you been to Aberdeen before?
@Martin Murchie I've sent you a LinkedIn connection request. I'm looking to setup and Aberdeen Power BI user group. Let me know if you or one of your team is interested in being part of the first meeting. Cheers Jason
There is a possibility to have two comparison values, thus 2 KPi indicators values, is it possible to create calculation to have the kpi indicator index to affect both kpi indicator values?
Hi Jason, hope all is well...I got a question if you could help with, how can we factor in a target that has two limits, e.g. budget target usually sets two limits of +5% or -5%, how can we measure against these two limits should we overspend or underspend? Additionally, can we use bullet chart instead of the default sparkline?
You'd need to modify the calculations for cost but the overall approach is to create a KPI that is true or false based on a compression with a budget target +/- 5%. The key is to convert the budget variance into an absolution values. It's all covered in the video though. In the example in the video I do it for each work order but I think you'd need to make that calculation for the granularity you are measuring the budget over i.e. YTD, Month, quarter etc. Let me know how you get on and if need be I can look to put a video together.
@@jasondavidsondata Great thank you for the prompt feedback and will check the video out... currently working on the Power Bi Goals, or whats called Metrics, video and alot to digest and will post some comment on your Goals video pretty soon :)
@@Moonknight7777d9 Igreat stuff. 'm going to do an updated video on metrics, there is a load of new functionality added. Hopefully it'll be ready by next weekend.
Very clearly explained all the features and how to use effectively, Thank you very much
Thanks for the comment and I happy you found it useful.
This is a fantastic video! Thank you, Jason.
This is a fantastic video! Thank you, Jason. These two videos are exactly what I needed. Cheers from Nashville.
Hi Nick, thanks for the comment all the way from Nashville! I'm glad you found this usefull. 👍
Absolutely well-made session for Power KPI Matrix. Thank you!
Thank you so much for sharing this details. It helps a lot !
That's great that I was able to help. 👍
Thank you... I´m learning a lot...
Hi, thanks alot! Is it possible to automate the format part (around 38:00)? Like by adding an extra column in the datasheet?
This is a great video Jason....Thank you. I just need to ask two questions please:
1) If I want to add the YTD value , Rating scores from 1-5 for every KPI and an Overall rating scores for all KPIs, could you please show me the steps on how to add these?
2)How to link the date with these values? because when i tried to select different dates the values are gone.
Maaaan, I'd definitely married you for being this wit about BI and data mgmt 😂
😂 we'd make lovely small multiples together.
Thanks for the video. This is helpful. I want to show each KPI value at different country level in the summary view, how can I do that? Please help.
i appreciate that thanks
Hi, Thanks for the comment. I'm glad you found it useful. Cheers Jason
god bless you thanks
Please help: My KPI Status shows up as a black + or - %. It doesn’t show the symbols or color even though I’ve added the KPI Indicator column. Not sure what I’m missing.
Is there a way to add a custom column say monthly commentary to the Power KPI Matrix table?
Hi this is really good video
I have a question
When you use var for kpi index, you don’t have to type measure but Var needs measure
How do you solve this problem? Thanks
Hi Jason. This is great. We're now using this as well as the Risk Matrix from your previous video. The only thing that's irritating me about the Power KPI Matrix is the row heights seem to have a mind of their own and I can't find a way of controlling them. (Also is that an Aberdeen accent?)
Hi Martin, Thanks for the comment. It's great you've found this stuff usefull! I've never had an issue with the row heights but I feel your pain, sometimes things happen that you just can't figure out.🙄. It sure is an Aberdeen accent. Have you been to Aberdeen before?
@@jasondavidsondata Born and bred. I'm the CDO at the City Council.
@Martin Murchie I've sent you a LinkedIn connection request. I'm looking to setup and Aberdeen Power BI user group. Let me know if you or one of your team is interested in being part of the first meeting. Cheers Jason
There is a possibility to have two comparison values, thus 2 KPi indicators values, is it possible to create calculation to have the kpi indicator index to affect both kpi indicator values?
Thank u
You are welcome :-)
Hi Jason, hope all is well...I got a question if you could help with, how can we factor in a target that has two limits, e.g. budget target usually sets two limits of +5% or -5%, how can we measure against these two limits should we overspend or underspend? Additionally, can we use bullet chart instead of the default sparkline?
Hi Feda, You could look at the approach I use in this video here th-cam.com/video/lJ0JOJrUvx8/w-d-xo.html
You'd need to modify the calculations for cost but the overall approach is to create a KPI that is true or false based on a compression with a budget target +/- 5%. The key is to convert the budget variance into an absolution values. It's all covered in the video though.
In the example in the video I do it for each work order but I think you'd need to make that calculation for the granularity you are measuring the budget over i.e. YTD, Month, quarter etc. Let me know how you get on and if need be I can look to put a video together.
@@jasondavidsondata Great thank you for the prompt feedback and will check the video out... currently working on the Power Bi Goals, or whats called Metrics, video and alot to digest and will post some comment on your Goals video pretty soon :)
@@Moonknight7777d9 Igreat stuff. 'm going to do an updated video on metrics, there is a load of new functionality added. Hopefully it'll be ready by next weekend.
@@l0verb0y20 Great and will be waiting for it :) Thanks for the ehads up :)
i have a question plz
Hi, what's yiur question? I'll see if I can help.
@@jasondavidsondata it's ok
thank you soooo much jason you saved me