Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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:
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
Solved! Go to Solution.
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.
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.
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
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.
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
32 | |
19 | |
12 | |
8 |
User | Count |
---|---|
52 | |
37 | |
29 | |
14 | |
12 |