Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
crisc
Helper I
Helper I

Scorecard - PBI Service

Hello everyone,

 

we were taking our first steps with the Scorecard feature in Power BI Service.

After creating a report-connected metric, we just had it running over june, which was great!

The connected-report has a filter tile for the month, which gets updated by someone in our team each month (so on 1st of july someone switched it from june to july).

The Scorecard metric still remebered 'june' as filter for the month and won't change its values.

 

My question here is:

Is there a way to make a metric in the Scorecard keep in sync with the filters in the underlying report?

What i tried already:

  • Create a simple report which gets filtered via the filter-pane (relative time filter to 'in the last day')
  • Filter data via SQL Query

 

I think the only thing i haven't tried is, set up an refresh schedule for the underlying dataset of the Scorecard.

(When i tried to, i messed something up and had the start all over from the start...)

 

If thats not the intended way to use a Scorecard, i really would appreciate some adivce for a use case.

 

Setting up a new Scorecard (or at least manually refresh all metrics) each month was the only way i was able to make this work - but thats a time consuming task, which is kind of the opposite direction we wanted to go with Power BI.

 

Best regards & thanks in advance

Chris

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @crisc ,

 

Daily tracking cycles can be created in the scorecard, which means that data and progress are calculated on a daily basis. However, many metrics and indicators require tracking at a different cadence. In these cases, you can change the default tracking period of the indicator via the indicator settings. The tracking period does not affect data refresh.

vhenrykmstf_0-1657266205070.png

More details, read below document:

Create scorecards and manual metrics - Power BI | Microsoft Docs


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
crisc
Helper I
Helper I

Hi @v-henryk-mstf ,

 

thanks for your reply!

I will give this a try - chances are good, that this might solve my issue since i haven't set a value there!

 

Best Regards,

Chris

v-henryk-mstf
Community Support
Community Support

Hi @crisc ,

 

Daily tracking cycles can be created in the scorecard, which means that data and progress are calculated on a daily basis. However, many metrics and indicators require tracking at a different cadence. In these cases, you can change the default tracking period of the indicator via the indicator settings. The tracking period does not affect data refresh.

vhenrykmstf_0-1657266205070.png

More details, read below document:

Create scorecards and manual metrics - Power BI | Microsoft Docs


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.