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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jmdoe
Regular Visitor

Scoreboard current value does not update to blank

Hi there, 

 

I'm using Power BI scoreboards to set up monthly targets based on operative metrics for my team to achieve. The targets are set on a quaterly basis but apply for each month of the quarter respectively.

 

The underlying report I created for the purpose of tracking progress includes data for the current month. At the start of the quarter, the metric will be blank. Throughout the first month, it will increase to e.g. 4 and then fall back to either blank or a lower value on the first day of the following month. 

 

While the scoreboard has no issue whatsoever to show blank values when first setting up a new metric (in this case it would show —/5), it will keep on showing 4/5 (value from previous month) instead of returning back to —/5 when the new (current) value is blank. If the current value is 0 or any other number e.g. 1, it will update correctly and show 1/5 upon month start. 

 

In edit mode when trying to rebuild the connection between the metric and the data report, the metric will show — after clicking on Connect, but then will show again the previous value 4 after clicking on Save. Attached are step-by-step reproduction steps:

 

Step 1: Go to edit mode. Current value shows 4. Go to Edit connections...

Step 1.png

 

Step 2: Select your blank metric. Click on Connect

Step 2.png

 

Step 3: Edit mode shows — as current value. Click Save

Step 3.png

 

Step 4: Reading view shows previous value again

Step 4.png

 

Is that a known issue or is there any other workarounds apart from creating a new metric each month?

 

Thank you for your help!

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors