Creating KRI dashboard with thresholds in Power KPI Matrix

Question

Hello V-viig and all,I am a beginner with Power BI and working on creating a Key Risk Indicators (KRI) dashboard. Power KPI Matrix definitely helps with KRIs also.I reviewed the PowerKPIMatrix 2.1.4 file to understand the basics. The&nbsp; sample&nbsp;file posted was&nbsp;beneficial.&nbsp;I am trying create my own KRI dashboard by tweaking that sample file instead of creating my own from scratch (I dont have such expertise with the tool yet).- How can I set different thresholds for different metric names? I think sample file applies same threshold to all KPIs- What should be my Calc Variance, Calc KPI index colums for below example?ExampleKRI1 - Green status if value&nbsp;is &lt;&nbsp;2%, Yellow between 2-4%, Red &gt; 4%KRI2 - Green if &gt;50, Yellow 50-35, Red &lt;35KRI3 - Green if &gt; 1%, Yellow 1-0.85%, Red&lt; 0.85%&nbsp;&nbsp;I gave you different scenarios so you can understand that some KRIs are numbers, some percentages and I am trying to display Green, Yellow, Red StatusI hope this question makes sense. Hope to hear back.&nbsp;https://visuals.azureedge.net/app-store/PowerKPIMatrix.2.1.4.0.pbix&nbsp;Sample file Power KPI Matrix File

v-evelk · Answer

Hello,&nbsp;Sorry for the delay. I am working on your question and will provide some instruction tomorrow.It will be better also if you sent your report to&nbsp;pbicvsupport@microsoft.com to let me better understand you issue.&nbsp;Thanks!&nbsp;Evgenii Elkin,Software EngineerMicrosoft Power BI Custom Visualspbicvsupport@microsoft.com

v-evelk · Answer

Hello,&nbsp;Could you clarify please what type of data structure do you use, Column-Based or Row-Based?&nbsp;Thanks!&nbsp;Evgenii Elkin,Software EngineerMicrosoft Power BI Custom Visualspbicvsupport@microsoft.com

cncnvr · Answer

Thank you for the reply, just sent you an encrypted email per your request.

v-evelk · Answer

Sorry, I cannot open link from your e-mail.&nbsp;If you user row-based schema you will need to create a 1 new column and fill it by indexes values (0,1,2) calculated for a measure and target value by criteria that you described and then use this field in "KPI Indicator Index" bucket and set up colors and icons for indicator indexes in "KPI Indicator" section.&nbsp;If you use column-based schema you will need to create a 3 new columns, set them in "KPI Indicator Index" bucket and manually map them for measure and comparison value ("Edit" menu item in the top right corner of the visual).&nbsp;Kind Regards,&nbsp;Evgenii Elkin,Software EngineerMicrosoft Power BI Custom Visualspbicvsupport@microsoft.com

cncnvr · Answer

If you user row-based schema you will need to create a 1 new column and fill it by indexes values (0,1,2) calculated for a measure and target value by criteria that you described and then use this field in "KPI Indicator Index" bucket and set up colors and icons for indicator indexes in "KPI Indicator" section. --- This is the part I am trying to do and dont know how to do?&nbsp;I understand you could not open the encrypted email, below is the screenshot of my sample data and what I am trying to do. Let’s do one example for the KRI below. I provide both the threshold (Red-Yellow-Green) and 4 months of sample data:ALLL/Loans&lt;0.55%0.55 - 0.75%&gt;0.75%&nbsp;&nbsp;MetricDateValueALLL/Loans12/1/20180.45%ALLL/Loans11/1/20180.80%ALLL/Loans10/1/20180.67%ALLL/Loans9/1/20180.92%&nbsp;What should be the formula in my “Calculated KPI Index” column in the sample file? My whole purpose is to modify this sample table to show relevant colors for my values when they are in the respective thresholds I point above.

Forum Discussion

Creating KRI dashboard with thresholds in Power KPI Matrix

10 Replies

Related content

Creating a Dashboard for operations

5000 threshold sharepoint connection - PBI

How to create a beautiful Power BI Dashboard/Report?

Create an Organisation chart Dashboard on PowerBI with interactivity

creating Data Quality Dashboard