cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Joey Frequent Visitor
Frequent Visitor

Power KPI Matrix: issue showing percentages in "Target" column

Hello,

I wanted some help with showing percentages in the Target column. I've been tinkering around with the Power KPI Matrix visual, and my current report looks like this:

P1.PNG

I'm having some difficulties with trying to make the percentages appear in this area (red circle).

P2.png

My target's table looks like this:

S1.PNG

It works fine for other numeric values, but for percentages, I can't get them to show up on the visualization.

Any ideas on how to solve this?

 

On that note, does anybody know how to show an indicator from the same period of the previous year using percentages (purple circle)? 

 

So, for example, I want to able to see my value column saying April 2018, there was a 92% fill rate, and on the left hand column which represents the last year to show April 2017, with a 85% fill rate. 

 

The closest I've gotten is to take an average of the percentages from the same period of last year:

08.2 YTD Prior =
            CALCULATE(
                       AVERAGE('Operaciones'[08.2 Fill Rate (%)] ),
                       SAMEPERIODLASTYEAR( DATESYTD(Fechas[Fecha] ) )
)

 

P3.png

 

Thank you for the feedback.

9 REPLIES 9
Moderator v-viig
Moderator

Re: Power KPI Matrix: issue showing percentages in "Target" column

It seems Target values of red sector are zero values or format specified improperly.

We would recommend to turn off Format Panel -> Current Value -> Treat zero values as nulls.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

 

 

Joey Frequent Visitor
Frequent Visitor

Re: Power KPI Matrix: issue showing percentages in "Target" column

It does not work because the column we are referencing is the "Comparison Value options".

So, current value does have the feature:

Format Panel -> Current Value -> Treat zero values as nulls.

But, comparison value does not:

Format Panel -> Comparison Value options -> (no option for that)

 

I can get the values to appear only when I use a constant measurement, but it defeats the purpose since different operations have different comparison values.

T1.PNG

Moderator v-viig
Moderator

Re: Power KPI Matrix: issue showing percentages in "Target" column

Could you describe how the Traget column values are calculated? Are values numbers?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Joey Frequent Visitor
Frequent Visitor

Re: Power KPI Matrix: issue showing percentages in "Target" column

It is just the percentage number as a value. It is not calculated. (eg: .95, .90, .98)

W1.PNG

I have to place them twice, one in january and anothe one in december, otherwise the target line doesn't work in the Trendline.

It works fine for numbers bigger than 1, but I can not get it to work with values between 0 and 1.

W2.png

Moderator v-viig
Moderator

Re: Power KPI Matrix: issue showing percentages in "Target" column

Is it possbile to share a report for furhter investigation?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Joey Frequent Visitor
Frequent Visitor

Re: Power KPI Matrix: issue showing percentages in "Target" column

I talked to my boss, and he said its ok to share the report.

 

Is there a email I can send it to you directly?

Moderator v-viig
Moderator

Re: Power KPI Matrix: issue showing percentages in "Target" column

Please send a .pbix file to our support email alias: pbicvsupport@microsoft.com

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

mikyi_ro Regular Visitor
Regular Visitor

Re: Power KPI Matrix: issue showing percentages in "Target" column

HI all, Is there any news on how we can add percentages as targets ? Thanks!
v-evelk Member
Member

Re: Power KPI Matrix: issue showing percentages in "Target" column

Hi,

 

I am trying to figure out wheter report was sent for analysis or not.

if you send it again it will help me significantly.

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com