Solved: power kpi matrix - Page 3

lburgess · ‎12-20-2017

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. I got it all configured and customized in Power BI Desktop, then published the report to the Power BI service. All of the customizations I had done to format Current Value and set colors for the Sparkline charts were lost. I had to re-do them in the Power BI service and save them there.

Is anyone else experiencing this issue?

v-viig · ‎01-09-2018

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

pbicvsupport@microsoft.com

View solution in original post

Van22 · ‎07-19-2018

Hi,

I'm relatively just a beginner in using this visualization tool and like your photo, I want to show Last Month's value on the table. Can you teach me to do that?

Thanks,

Van

Van22 · ‎07-19-2018

Hi Guys,

I'm just a new user of the Power KPI Matrix and I want to show Last Month's Value as Second Comparison Value but when I map the measure, it's not showing on the table.

The values are formatted as Percentages. Thanks for any help you may give.

Regards,

Van

v-viig · ‎07-19-2018

As a first step we recommend to download Power KPI Matrix sample report to understand how it works.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Van22 · ‎07-19-2018

Hi,

I'm relatively just a beginner in using this visualization tool and like your photo, I want to show Last Month's value on the table. Can you teach me to do that?

Thanks,

Van

v-viig · ‎12-22-2017

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

pbicvsupport@microsoft.com

lburgess · ‎12-22-2017

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!

numbersei · ‎12-27-2017

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

v-viig · ‎12-27-2017

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

pbicvsupport@microsoft.com

KWILL · ‎01-22-2018

Any update on this release?

v-viig · ‎01-23-2018

Power KPI Matrix will show the zero value as is and render Sparklines properly.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

KWILL · ‎01-23-2018

Hi Ignat,

I just updated the visual and it's still defaulting to the previous day. When I click the desired day it's just showing a blank space instead of a zero.

How do I fix this? I tried deleting and re-importing the visual and I'm getting the same undesirable result.

Thanks!

v-viig · ‎01-24-2018

Did you turn off Treat zero values as nulls option at Current Value?

Is this option available at Format Panel -> Current Value?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

KWILL · ‎01-24-2018

Perfect, thank you!

chiragbagga · ‎01-02-2018

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

Robbief · ‎04-18-2018

@chiragbagga-- Could you share the PBIX of how you got the visual to look like that?

pcraokjr · ‎03-20-2018

Hi Chrig

I'm using Power KPI Matrix latest version PowerKPIMatrix.2.1.1.0.pbiviz, but unfortunately its not displaying the KPI Indicators icon which set as part of KPI Indicator formatting menu. How did you manage to display KPI Indicators icons. Please provide solution if you come across any problem while exploring this visual.

Thanks

ccjs · ‎03-20-2018

I may be experiencing the same issue as pcraokjr, though I had been waiting for the March Report Server version to see if it made any difference. After testing a report I'm working on, I went back to the example file from https://visuals.azureedge.net/app-store/PowerKPIMatrix.2.0.0.0.pbix and found the same thing. It seems that no matter how I configure a *.pbix file in the Desktop version, when it's displayed on the Report Server I lose any actual indicator symbols available in the "KPI Status" column. I've tested all indicator symbols available, and although I can get a percentage to display and the colors to match, I have different scales across KPI's so a status symbol is more useful.

Could this be an issue with the Report Server, or is this something related to the visual? My apologies if this question has already been addressed, but I wasn't able to find an answer.

Thanks!

pcraokjr · ‎03-23-2018

Hi

I found the solution for my issue....KPI icon not dispalying in desktop version but once its file loaded to PowerBI site, i can see the KPI Icon.... this doesnt make any sense for me.... its wasted lot of my time.

Thanks