cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leunjoh
Frequent Visitor

Power KPI Matrix - Losing Format after Refresh - Row Based

Hi there, I'm finding I'm losing my Number Format after making changes on my Row Links.

 

Here's my steps in the PowerKPIMatrix 2.1.4 file for example

1) I change the formatting for Current Value for Total Units to display Thousands

2) I change the source file in Excel (I extracted from the tables) for Row Links for KPI Total Units from bing.com to bing.ca

3) I refresh the file

4) the formatting for Total Units is lost and I'm no longer displaying Thousands Is anyone else having this issue?

5 REPLIES 5
v-viig
Community Champion
Community Champion

This is expected behavior if you change data rows because Power KPI Matrix binds settings to data rows.

There're a few technical limitations that prevent us from fixing it.

 

We'll update once it's implemented.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

 

I am experiencing the same issue. Is this something that is on the planning for the team? Do you have a suggestion for a workaround (without switching to a column-based data scource)?

 

Thanks a lot in advance.

v-viig
Community Champion
Community Champion

This issue is still in backlog due to technical limitations. We'll update once they are resolved.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Hi, Is there any updates on this one? I would also need to bind the format to a certain metric without losing the formatting every time I add/delete a metric from the visual. It's very painful to always reformat everything while I don't understand what is causing the formats to change. 

 

Thanks, Oskari

ksshus
Frequent Visitor

Is there any update on the fix?
We have 100 metrics using this visual listed on the rows. Everytime we add a new metric, it's painful to update format for each.

 

Thanks.
Kelley

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors