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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Power KPI Matrix Visual Issues

Hi Team,

 

I am unable to get the "KPI Status" and "Comparison Value" fields to work in the Power KPI Matrix Visual even with the same data in the sample file for the visual.

I checked all the options and tried to replicate the visual exactly as it is in the sample and it stil does not work.

 

Am I doing something wrong or is th visual no good. I can share the file if needed.

 

 

Status: Needs Info
Comments
Staeven
New Member

Hi @Qiuyun Yu

 

Thank you for your kind offer of assistance.

As I am using an SSAS Tabular model cube as my dat source, dummy data is not practical.

 

It is quite possible that I misunderstand the concepts behind the Power KPI Matrix visualisation.

 

These screen shots provide more information about the data.

First image presents my data in a table.

This includes the SSAS KPI along with the new 1,2,3 index I added for use with the new visualisation.

 

The second image shows the visualisation with empty KPI Status and Comparison value.   I have also included parts of the Power KPI visualisation that shows works as expected.

 

Kind Regards,

Staeven

 

2018-01-09_7-20-17.jpg2018-01-09_7-27-57.jpg

 

GCL
Frequent Visitor

Hi Manny,

 

I wouldn't use such a dataset... because:

- column D / F / H  are redundant;

- the "KPI Status" is not available.

 

Suggestion:

- step 01: make the columns A / B / C / E / G  available in Excel - Power Pivot

- step 02: define one measure for each column C / E / G  ( e.g. Average of all values in the column )

- step 03: define one (target) measure for each column D / F / H

- step 04: right click the measure defined in step 02 - Edit KPI settings

- step 05: Edit KPI settings - the "measure" = the target measure defined in step 03

- step 06: ( import this Excel in Power BI Desktop + apply the "PowerKPIMatrixEB" ) or use Power View

- interesting link: https://support.office.com/en-us/article/Key-performance-indicators-KPIs-in-Power-View-230D7F15-731E...

 

Success!

Gaston

Manny
Frequent Visitor

@GCL thank you for your reply. I followed your procedure and had the same results. KPI Status and Comparison value do not show. I am having the same exact problem as shown by @Staeven.

 

The PowerKPIMatrix1.0.1.pbix shows this example.

 

PowerBI_PowerKPIMatrix_Column-Based_Data.PNG

If you export this data and then import it into a new Power KPI Matrix visusal, it also has the same problem.

GCL
Frequent Visitor

Dear,

 

Considering the second image of Staeven : this configuration is not correct.

Suggestion:

 - stick to the "Production KPI" ( and do not mix the kpi fields )

 - define the STATUS in the "KPI Indicator Index"

 - define the GOAL in the "Comparison Value"

 - define the VALUE in the "KPI Indicator Value"

 

 - define your "Row-based Metric Name" (related to "actual production")

 

Latest update related to the Power KPI Matrix: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381299?src=office&tab=Overview

and consider the info at the bottom of this page -> "PowerKPIMatrix.2.0.0.0.pbix"

 

Cheers!

Gaston

 

Manny
Frequent Visitor

@GCL thank you for your support. Following the guidance from PowerKPIMatrix2.0.0.pbix my issue has been resolved and my production data as a Column-Based Data Model is now working!

jeyakumarvs
Regular Visitor

Hello,

 

The same issue has been encountered during my experience with this custom visual. Please assist me fix this. Thank you!

 

Validation Power BI file URL: https://1drv.ms/u/s!AqnqE1fQbvGWhUl4zpn8_JVBPoxm

 

Note: This was developed on the basis of the sample version PowerKPIMatrix.2.1.2.0.

 

 

Manny
Frequent Visitor

The reason why it doesn't show is because you have not done the mapping yet. So on your visual...clik on the ellipse and clikc on edit. From there you will see the mapping exercise required for the comparison and KPI to show up.

jeyakumarvs
Regular Visitor

@Manny,Thank you and it worked... Somehow I missed this settings while go through the documentation or YouTube video for this visual.

Manny
Frequent Visitor

No problem...it was simple and I missed it the first time too.!

MargotBKAD
Regular Visitor

Just check in the Power BI Query that the column containing the KPI indicator is defined as a "Whole number", otherwise you won't be able to see the markers.