Forum Discussion

PaulDBrown's avatar
PaulDBrown
Community Champion
8 years ago
Solved

Power KPI Matrix: Am I doing something wrong? Line is blank when it shouldn´t be

Good evening,   I've been trying out the Power KPI matrix to compare sales estimates vs budget and previous year. The problem arises when for a given channel, the estimate (see attached screenshot-...
Help
  • v-viig's avatar
    v-viig
    8 years ago

    Hello PaulDBrown,

     

    Power KPI Matrix doesn't render any values if Actual Value is not a valid value (empty or null).

    Please specify a valid not zero value for Actual Value to fix this issue.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

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

    We're going to release Power KPI Matrix 2.1.0 next week that supports zero values.

    Once this version is released you might try to set null value to zero to render the column.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

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

    Power KPI Matrix 2.1.0 has already been released.

    Zero values can be turned on in Actual Value group of formatting panel.

     

    Please let me know if this feature meets your initial requirements.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thank you very much for your reply- in a similar vein, can you tell me where to find the swtich to turn on Category and SubCategory is?

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

Categories can not be turned off by design.

Sub-categories can be turned off by removing columns from Category data-field.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]