PowerKPI custom viz "KPI Indicator" option not always visible

[vrocca]

I am having issues getting a consistent behavior to get the "KPI Indicator" option to be available in the visual. I can get it to appear for certain "Dates", but it is not always showing up.

What are the requirements to have the "KPI Indicator" option to appear in the visual?

[v-viig]

Hello @vrocca,

It'd be good if you can take a look at the KPI Indicator Instructions page of sample file.

There's the guide about usage KPI Indicator.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[vrocca]

Hi @v-viig,

I think I found the issue on my end. It looks like following the documentation creates different behavior if the data is not plotted at the same granularity as the sample file. Specifically, the "KPI Index" value should be a measure - for example, if you have your data at a daily level (as in the sample file) and want to show a KPI at a monthly level, the KPI Index column will incorrectly sum up the values for the month and give you a number other than 1,2,3 - This breaks the ability to view the KPI Indicator.

If it's setup as a measure, it will evaluate the sum of the Variance at the monthly level and then determine if it's >0.05 or <0.05. 

Lastly, the documentation refers to a "KPI Symbol Index" field well. This looks to have been renamed/replaced by "KPI Indicator Index."

Thanks,

Victor

[v-viig]

Power KPI shows KPI for the latest available date (if current value and target value is available).

This behavior requires to use the measure column that determines KPI Indicator Index for each date (data-point).

I'd also note that Power KPI is designed to support any granualiry.

Please let me know if you have any questions.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[vrocca]

See sample below for the behavior I'm referring to:

https://app.powerbi.com/view?r=eyJrIjoiOWQ5ZTUzY2MtZWRhMi00Nzk5LTk2OTMtZTdlZjg1OGExZDY0IiwidCI6IjIxN...

[v-viig]

I think you should create a new Measure using this DAX: LastKPIIndex = LASTNONBLANK(Data[KPI Index], 1).

This column should be used be used in Power KPI instead KPI Index column.

Please let me know if that works well for you.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com