Showing results for 
Search instead for 
Did you mean: 
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 to

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?

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


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.

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

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

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.



Helpful resources

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!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors