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

Re: power kpi matrix

Hi @v-viig,

 

I did that, but no luck Smiley Sad

 

Thanks,

Sujith.

Highlighted
Moderator v-viig
Moderator

Re: power kpi matrix

Can you share a pbix report to reproduce this issue on our end?

 

You can share via email: pbicvsupport@microsoft.com

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

fbeekvel
Advisor

Re: power kpi matrix

Thanks for this great visual, it works pretty well for me.

 

Only one thing is a bit annoying. It always shows the data for the last value of the selected date field. In the Actual and Comparison values I would like to show an average for the selected dates (which is exactly what my underlying measure calculates), but this is not working now because it now only takes the "average" for the last date.

 

Could you consider adding the option to show the "total" for the selected date fields instead of only the last one?

Or provide an option to use a different field in the spark line than the one in Date, that would be even better perhaps.

Moderator v-viig
Moderator

Re: power kpi matrix

@fbeekvel Thanks for the feedback. An ability to use another data field for sparkline has been added to the backlog (#26424).

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

pnsujith Frequent Visitor
Frequent Visitor

Re: power kpi matrix

Hi @v-viig,

 

I have sent the pbix file to recreate the issue.

 

Thanks,

Sujith.

Moderator v-viig
Moderator

Re: power kpi matrix

Thank you. I'll look into it.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Mvumelwano Regular Visitor
Regular Visitor

Percentage of Row Total

HI Guys

 

Please help me... i have been struggling the whole day with this formula.

 

How do i change the hilighted formula (Red) to give a percentage of row total.

 

My current formula is giving the sum of selected Level5 for the selected Month.

 

Current formula answer  = 2 (hilighted Orange)

 

Requested formula  = 2 (hilighted Orange) / 5 (hilighted Blue)

 

 

Kind regardsExample.PNG

Nocha

Moderator v-viig
Moderator

Re: Percentage of Row Total

Hi @Mvumelwano,

 

We'd recommend to ask this question in this thread instead.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

iNuii Frequent Visitor
Frequent Visitor

Re: power kpi matrix

@v-viigDo you have any tutorial for the power kpi matrix?

as I will build a monitoring dashboard for my company KPI.

 

I got the information as in picture, can you give any advice?

 

Thank you in advance

 

DB.png

slan2018 Frequent Visitor
Frequent Visitor

Re: power kpi matrix

@v-viig Good morning,

I'm using the Power KPI Matrix and it seems to have all the features I need, but I'm unable to figure out how to display the KPI indicator symbol on the Second KPI Status column.  Any ideas?7-10-2018 8-43-00 AM.jpg