cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rossnruthie Member
Member

KPI display yearly average with month over month trend

I have a KPI that I am trying to set up but running into a problem.

 

Given the following KPI:

Capture.PNG

 

I would like the value of 99.98% to represent the overall average year to date success while the background trend represents the month over month success.  I can seem to only format it so that the main value is the most recent value in the trend.  Is there any work around for what I'm trying to do?

 

Thanks,

Brian

1 ACCEPTED SOLUTION

Accepted Solutions
Baskar Super Contributor
Super Contributor

Re: KPI display yearly average with month over month trend

Hi,

 

 

You can drag the month fileld in Axis it will show month level %.

 

In this KPI accept onle one Measure, we can 't set two measure like 1 for Label and another one for background..

 

Is not possible here sorry

View solution in original post

6 REPLIES 6
Baskar Super Contributor
Super Contributor

Re: KPI display yearly average with month over month trend

Hi,

 

 

You can drag the month fileld in Axis it will show month level %.

 

In this KPI accept onle one Measure, we can 't set two measure like 1 for Label and another one for background..

 

Is not possible here sorry

View solution in original post

Moderator v-qiuyu-msft
Moderator

Re: KPI display yearly average with month over month trend

Hi @rossnruthie,

 

Based on my understanding, you want to display average of one year value as indicator, and month as background trend in a KPI visual, right?

 

In a KPI visual, the trend axis is displayed as the background of the KPI visual. In your scenario, you can add average of one year value fields in Indicator and Target Goals properties, then place month field in Trend Axis property. For more information, please refer to this article: KPIs in Power BI.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rshetty Visitor
Visitor

Re: KPI display yearly average with month over month trend

I would like the value to represent the overall average year to date while the background trend represents the month over month success.  I can seem to only format it so that the main value is the most recent value in the trend. 

 

Is this possible?If yes then how to implement this.Any help would be really great.

dmarti44 Frequent Visitor
Frequent Visitor

Re: KPI display yearly average with month over month trend

I am also struggling with this question.  My company has a weekly KPI target so I can use the KPI visual to dispaly the performancy weekly on the trend axis as well as the target goal.  But in the value displayed in th middle of the visual it is more valuable to our company to see the average weekly performance over time rather than the weekly performance on the last point in time which is how it currently displays.  If this is not possible to show in Power BI's current version, can you add this feature to future versions?

dmarti44 Frequent Visitor
Frequent Visitor

Re: Re: KPI display yearly average with month over month trend

I am also struggling with this question.  My company has a weekly KPI target so I can use the KPI visual to dispaly the performancy weekly on the trend axis as well as the target goal.  But in the value displayed in th middle of the visual it is more valuable to our company to see the average weekly performance over time rather than the weekly performance on the last point in time which is how it currently displays.  If this is not possible to show in Power BI's current version, can you add this feature to future versions?

dmarti44 Frequent Visitor
Frequent Visitor

Re: KPI display yearly average with month over month trend.

I am also struggling with this question.  My company has a weekly KPI target so I can use the KPI visual to dispaly the performancy weekly on the trend axis as well as the target goal.  But in the value displayed in th middle of the visual it is more valuable to our company to see the average weekly performance over time rather than the weekly performance on the last point in time which is how it currently displays.  If this is not possible to show in Power BI's current version, can you add this feature to future versions?

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)