Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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?

6 Replies

  • v-viig's avatar
    v-viig
    Community Champion
    8 years ago

    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

    [email protected]

     

    • BartOnline's avatar
      BartOnline
      New Member
      7 years ago

      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's avatar
        v-viig
        Community Champion
        7 years ago

        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

        [email protected]