Metrics Scorecard Visualisation Doesn't Return values for 0

zantarel — Thu, 27 Jul 2023 12:51:45 GMT

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!

Re: Metrics Scorecard Visualisation Doesn't Return values for 0

Anonymous — Tue, 03 Sep 2024 16:19:36 GMT

Looking for a solution to this as welll, absolutely desperate

topic Metrics Scorecard Visualisation Doesn't Return values for 0 in DAX Commands and Tips

Metrics Scorecard Visualisation Doesn't Return values for 0

Re: Metrics Scorecard Visualisation Doesn't Return values for 0