Power KPI Matrix - Losing Format after Refresh - Row Based

[Anonymous]

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?

[v-viig]

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

[BartOnline]

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]

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

[Anonymous]

Has this issue been updated?

[OskariNi]

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

[Anonymous]

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