Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Automated Status rules for metrics doesn't update if number becomes blank

Hi All,


I have a power bi metric created with a current value that connets to a dataset. This then has a status rule that if the values becomes less that 20 then mark as overdue otherwise leave as on track.




My issue is that when the number gets removed from the dataset/report (which happens when the number becomes 0) the status doesn't update to overdue. It seems to count blank as being "On Track".


There is no option on what to with blank numbers or if the data doesn't get detected.

I am not sure if i have done something wrong as it feels logical for this to be counted in the status rules.

Community Support
Community Support

Hi @username2345 ,


Theyonly work on refreshed data. They don't work on static data.

Have you try to create a measure to do an IF(ISBLANK(),0,<something>) ?

You may check if it works in the method above.


Best Regards,
Community Support Team _ Caitlyn

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


Best Regards,
Community Support Team _ Caitlyn



The data is not static. The value comes from a connect dataset (which is why I mentioned a dataset). For example:

on day 1 there's a an item APPLE with qty 50

On dayy 2 the qty goes to 0

The item apple is removed from the dataset (as it's no longer in stock)

So now the value shown in goals is blank till when it next is in stock



My issue that it doesn't take the value being not found anymore or being blank as a criteria in the status rules. Which is a scenario which can happen for various reason.

A measure will not fix this as the goal will simply not find it in the data set.


How can I account for this to make the status update.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors