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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Power KPI Matrix - Error rendering Flyout when Automatic formatting is selected

Hello,

 

I have an issue with the Power KPI Matrix. 

 

The issue occurs when I click a trendline for the flyout while utilizing automatic formatting of my values (Targets and Actuals). Instead of a line graph with 2 values (Actual and Target) and a KPI I get a render error with a blank chart.  It worked fine for months and then this happened within the last month or two months back. 

 

Thank you

 

Error Message:

Cannot read property 'max' of undefined.

 

Formulats

section Section1;

 

Performance Trace: 

ObjectCacheSessions/CacheStats/Size {"Start":"2018-08-08T19:58:15.3525054Z","Action":"ObjectCacheSessions/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":1924,"Tid":16,"Duration":"00:00:00.0012267"}
ObjectCacheSessions/CacheStats/Access {"Start":"2018-08-08T19:58:15.3552346Z","Action":"ObjectCacheSessions/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":1924,"Tid":16,"Duration":"00:00:00.0000244"}

ObjectCacheSessions/CacheStats/Size {"Start":"2018-08-09T14:30:27.1541657Z","Action":"ObjectCacheSessions/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":12588,"Tid":17,"Duration":"00:00:00.0000860"}

ObjectCacheSessions/CacheStats/Size {"Start":"2018-08-09T13:21:22.7009389Z","Action":"ObjectCacheSessions/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":16308,"Tid":8,"Duration":"00:00:00.0000522"}
ObjectCacheSessions/CacheStats/Access {"Start":"2018-08-09T13:21:22.7010246Z","Action":"ObjectCacheSessions/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":16308,"Tid":8,"Duration":"00:00:00.0000141"}
ObjectCacheSessions/CacheStats/Access {"Start":"2018-08-09T14:30:27.1542768Z","Action":"ObjectCacheSessions/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.61.5192.541 (18.08)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":12588,"Tid":17,"Duration":"00:00:00.0000233"}

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @Sowings,

 

What do you mean about "utilizing automatic formatting of my values (Targets and Actuals)"? Would you please share a pbix file to reproduce the issue? 

 

Please run the latest August Power BI desktop and Power BI KPI matrix visual. 

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Status changed to: Needs Info
 
Sowings
Regular Visitor

What I meant was I have Actuals under Current Value and Targets under Comparison Value. These two values were set to Automatic Formatting for months of use then one day the KPI stopped properly displaying the flyout with Automatic Formatting on.

 

I unfortunately can not share a PBIX file with the error. My source is an SSAS cube housing all in-house metrics and I lack the ability to add new cubes for demo purposes to our On-Prem gateway.

 

I will include some screenshots however.Before FormattingBefore Formatting

 Here you can see the flyout works fine.

 

After FormattingAfter Formatting

 When I turn on Automatic Formatting the Measures show up but the chart fails to render.

 

 

It has been happening on the last 3 release versions of Power BI Desktop software (Jun/Jul/Aug) and I have updated the Visual Component several times between then and now and it is still an issue. 

 

Let me know if there's other information I can provide.