Forum Discussion

lburgess's avatar
lburgess
Helper II
8 years ago
Solved

power kpi matrix

Not sure whether this is the correct location to post this, but here goes...   I downloaded the new Power KPI Matrix today. It provides the balanced scorecard reporting that I had been looking for....
  • v-viig's avatar
    v-viig
    8 years ago

    Power KPI Matrix supports zero values now by enabling a toggle at Actual Value group of Formatting Panel.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

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

The first issue is related to some recent changes of Power BI platform.

We're working in touch with Power BI Desktop team to address this issue.

The current workaround is to publish the report to PBI web and apply formatting options manually one more time.

 

The second issue is actually by design.

It was the inital requirement to filter 0 and nulls (empty values).

 

Does the second issue have high impact for your report?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

lburgess's avatar
lburgess
Helper II
8 years ago

Re the second issue, yes.  If the reported value is 0, that says that no progress has been made towards the KPI.  I understand filtering out nulls, but 0 is a valid value. As it stands today, we are unable to use the visual because of this issue.

 

Thanks!

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

    We'll discuss this issue internaly and get back soon.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I have the same problem. For me, 0 is a valid value. 
    Thanks for support!

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

      Power KPI Matrix 2.1.0 is going to support zero values by enabling a special toggle at Actual group of format panel.

      The release is expected in January.

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • chiragbagga's avatar
        chiragbagga
        Advocate I
        8 years ago

        Hi,

         

        I have another issue with formatting. I have custom column colors for each Metric Name. However, when the page is filtered by various other visualizations, the formatting is mixed up.

         

        below is the original as set:

         

        and below is when the page is filtered by other visuals:

         

         

        Please advise.

         

        Thanks,
        Chirag