Forum Discussion
power kpi matrix
- 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
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
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
- v-viig8 years agoCommunity Champion
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
- v-viig8 years agoCommunity Champion
Thank you for raising the issue with KPI Indicator in Power BI Report Server.
This issue is related to PBI Report Server as it doesn't have the special font with indicators.
We'll investigate the issue deeper and fix it soon.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
- Anonymous8 years agoNot applicable
Hi v-viig,
We have been unable to add this visual to the organization visuals section in our tenant because of the message "Legacy visuals are not supported." Are there any plans to update this visual and the other Power KPI visual so that they can be used in organization visuals?
Thanks,
James
- v-viig8 years agoCommunity Champion
ryan-gerres This is known issue of Power BI platform that is under investigation.
I hope that Power BI Core team will resolve this issue soon.
chiragbagga This is actually one of limitation of Power KPI Matrix since we bind formatting options to data-rows.
This is why some options might unset after we apply a filter or selection.
Our recommendation and current workaround is to apply a filter first. After that you should change formatting options of Power KPI Matrix.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
- chiragbagga8 years agoAdvocate I
v-viig Thanks for your response. I've tried applying the filter and then formatting the way I want it. however when the filter is changed or cleared during use of the report, it replicates the same issue. Please advise as this is not how it should work. Secondly, is a fix being worked on for this? I wouldn't imagine a visual being made with the expectation that filters will not be used.
Your help is much appreciated. i was using another visual called KPI Ticker by MAQ software. For somereason afterupdating power BI, it lost its alignment making it useless for my purposes. I like the power kpi matrix visual and would appreciate if you can fix this issue.
- v-viig8 years agoCommunity Champion
We aren't able to fix this issue due to Power BI platform limitation.
We'll look into this issue deeper from platform's side to fix the issue.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
- lburgess8 years agoHelper II
I presume your comment rgarding being unble to fix this issue is with regard to the formatting issue. Any progress on the zero values issue?
- lburgess8 years agoHelper II
Perfect! Thanks!
- chiragbagga8 years agoAdvocate I
v-viig Please advise where can I has more insight to resolution of this issue. As this is an issue in the visual / platform which hinders its use. I would appreciate if I can somehow be informed of the progress. I would understand that there may be other issues being looked at with the platform. Is there a progress / update page/ link/ forum for this ?
Thanks
- v-viig8 years agoCommunity Champion
chiragbagga We'll update this topic once we get any news about the issue.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
- Anonymous8 years agoNot applicable
Hello,
Can we please get this feature of showing zero values for the Comparison Value and the Second Comparison Value?
Thank you for your time.
- v-viig8 years agoCommunity Champion
Hello Anonymous
We'll consider this feature in upcoming versions of Power KPI Matrix.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
- Anonymous8 years agoNot applicable
v-viig Thank you for your response.
It causes some confusion with people because they believe data is missing.
I tried doing a work around where I would place a value of .00001, but that also has its complications because the KPI Status will throw a huge figure in precentage increase.
Anyways, thank you for looking into this.
Joey
- v-viig8 years agoCommunity Champion
Thank you for the details.
We'll implement zero-value support soon.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
- BetterIdeaGroup8 years agoHelper II
I was looking to interate off the sample data but it's looking for a file not provided. Any chance to get that sample data uploaded rather than recreating?
It was looking for:
C:\Users\gregkoe\OneDrive - Microsoft\PBI\PowerKPIMatrix_SampleData.xlsx
- v-viig8 years agoCommunity Champion
Currenly we don't have the original data in excel format.
We'd recommend that you should export data from the sample pbix report.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
- BetterIdeaGroup8 years agoHelper IIThank you for your post, I did that for the operative table, I just wanted to post since I thought it would be useful to have it easily available so everyone didn't have to do that
- lburgess8 years agoHelper II
Still waiting on solution to the visual losing the custom formatting after it is published to the PBI service. Actually, something is causing that formatting to return to the default after an unknown period of time or an unknown event. This could be a great visual but the formatting issue is a show-stopper to a significant degree.
- pcraokjr8 years agoFrequent Visitor
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
- Anonymous8 years agoNot applicable
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!
- pcraokjr8 years agoFrequent Visitor
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
- pcraokjr8 years agoFrequent Visitor
Hi
I'm using Power BI Desktop Feb 2018 and not tried March 2018.
Thanks
- v-viig8 years agoCommunity Champion
We would recommend to use March version of Power BI Desktop.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals