Metrics Scorecard Visualisation Doesn't Return values for 0

[zantarel]

Hi everyone, 

We've got quite a lot of scorecards running on our datasets in PowerBI. We then use these scorecards, which record numbers each week day, to graphically show progress towards a target. The issue I have found is that when that target 0, and when it is met, the scorecard doesn't show it as I would expect. For example: 

You can see that this Scorecard went to 0 on 19th April 2023. It has been at 0 since then. I think the problem is that the scorecard is recording a null value, as opposed to a Zero. When we go into a powerbi report and use the Metrics (Preview) visualisation, I presume because of these null values, the graph only goes up to 17 April, and then just stops. 

I have tried adding the scorecard as a dataset and selecting the goal name etc, so it's a 'normal' line graph, giving me access to a lot of the settings that you don't get with a Metric. But the issue here is if I select 'show null values', we have some days missing within the dataset (for reasons I won't go into here, and will continue to have), and then we get a graph that looks like this: which is also not ideal. 

Any ideas? I know the Metric visualisation is still in Preview etc, but it'd be really nice if we could make the scorecards record a 0 rather than 'blank' or 'null', so that the visualisation is better.

Thanks! 

[Techstack000]

Looking for a solution to this as welll, absolutely desperate