Rendering graph with null values, Power KPI Matrix
I want to use Power KPI Matrix to show a monthly accumulated KPI with Actual value and Comparison value. In the dataset the Actual value is null for days after today, and the Comparison value is set for every day through out the month. Now, it appears the graph doesn't render if Actual value is null. The behaviour I would expect is the graph redering if either Actual value OR Comparison value is not null. I've tried the feature "Treat zero values as nulls" but see no use for it in this case, since it creates a drastic drop in the graph that would likely lead to misinterpretations. The behaviour I'm looking for is shown in the Power KPI Visual small multiples example in this blog post: https://powerbi.microsoft.com/en-us/blog/balanced-scorecards/Power KPI Matrix 3.1.1 no longer displaying on Report Server
Hi I have previously managed to succcesfully use the Power KPI Matrix visual on our Power BI Report Server (And currently have a report on there that's working fine). I've just tried to to develop a new report with a Power KPI Matrix visual setup exactly the same as before. It works perfectly with in the Desktop software but when I open the file on the Report Server I get the message "To see this custom visual, add it to this report first: powerKPIMatrixEB2381CC88A8425FBEB1B07FF57784E6" I'm presuming this is to do with versions of things not being aligned, maybe PowerKPIMatrix has recently been updated and only works with Power BI Service at the moment. Is there anything I can do to get this working again? Cheers Mark Desktop version: Microsoft Power BI Desktop (Optimized for Power BI Report Server - September 2022) Report Server version: 1.15.8300.38452 (September 2022) Power KPI Matrix version: 3.1.1
Power KPI Matrix - bypass KPI Indicator Value automatic calculation
Good afternoon, I'm using the Power KPI Matrix visual to compare performance of KPIs versus to LY and 2 years ago (2LY). When comparing a percent metric, I'd like to put basis point change into the KPI Indicator Value and Second KPI Indicator Value fields, but as of now the KPI Indicator Value is being pre-calculated instead of using the field I provided. Looking at the sample file, I understand it states that this value is pre-calculated. Is there a way to bypass that automatic calculation for the KPI Indicator Value, as is possible with the Second KPI Indicator Value? Sample File: Metric Example: Appreciate your help, -AndyPlease help add KPI indicators for auto calculated variances with Power KPI Matrix
I have a simple set of KPIs and I am use a current month and comparing against previous month. I am using column data model with dates as rows and KPIs as columns. I can't seem to figure out how to automatically add green up arrows for positive variances and red down arrows for negative variances. How do I go about adding a simple up/down green/red KPI indicator to each variance calculation that is done automatically in the list of KPIs? I read the instructions about using Method 2 for a calculated column but in this case would i have to create a new calculated column for every single KPI even though they are all being calculated automatically? I am not understanding. I simply want to add the indicator to the already automatically populated column of variances between actual and comparison columns. Any help would be appreciated!Power KPI Matrix: Text Replacement for Current Value
I am using P. KPI Matrix to display Row based metric. Here is a summarization of my scenario: 1) I have a date filter to adjust window of Metric value 2) On certain days, some of the metric values are not available, so I want to replace those with a value in Text Replacement, such as "Not Available". Although I am able to select individual columns from Format>Current Value and replace these values with a text, however as soon as I change the Date range on date filter, the replacement values are lost. I was also trying to set the text value in the data set, but the metric values has to be numeric, so this isn't working. I am not sure if this is a feature where the text replacement will revert when chaning the date range on date filter. I also notice, it only happens when I change the lower date range but not the upper. On switching the lower date range to a value for which Text replacement was defined, the values are restored. To summarize, I am looking for a way to set hard coded text string for certain metric values.PowerKPI Matrix - date field w/out Standart PBI date-hierarhy from SSAS - question
Hi PBI community! I need help - I ve got SSAS model without standart PBI date hierarchy. There's a bunch of selfmade ones. I need to see the sparkline with dates - but the range of dates for the PowerKPI matrix needed to be current month and in columns I need agregated data for the whole period - not last date. Thanks!Power KPI Matrix Setting Targets
How do I create these targets in the right format for the Matrix? I'm trying to use the KPI Matrix (imported from marketplace) and looked through this tutorial . I've gotten my matrix to look like this, I need help with KPI Status and Comparison Values. 1. Comparison Values Some of the targets I sent are static numbers and some are dynamic. Example: Metric - Cycle Time Comparison Value - 55 days (static) Metric - Number of Completions Comparison Value - Change from previous month (dynamic) 2. KPI Status From what I've seen this is a mix of KPI Indicator Index and Indicator Value -- how do I manipulate my data or construct a table or measure to correctly show these? Any help very appreciated!Power KPI Matrix - "second KPI Indicator Value" and sparkline formatting
In the Power KPI Matrix sample report "PowerKPIMatrix.2.1.4.0.pbix" their is an instruction page of "KPI Indicator Instructions". On it there is a yellow card describing "Do you support KPI values from Analysis Services (Such as -1, 0, -1)?" which says: Yes, you can map the desired numeric index value to each KPI. The default Value is "1" for KPI 1; "2" for KPI 2", etc. However, you can change KPI 2 to use a value of zero and KPI 3 to use a value of negative one, etc. Power KPI Matrix has a similar column to "KPI Indicator" (titled "KPI Status" on the sample report) of "Second KPI Indicator Value" (titled "To Prior Year" in the sample report). This column does not appear to apply any of the formatting from the "KPI Indicator" formatting section, custom or otherwise (My data source is SSAS MD KPIs). How can I have the "Second KPI Indicator Value" be similarly coloured? Thanks Gord
