KPI not showing goal without data for a certain date

[ademooij]

Hi,

As per the above screenshot you can see I have a red box with 5 targets not showing the goal due to there not being any data yet for them on this day. I would however still want to show that these targets are behind goal. Is there anyway to have this visualised?

Thank you,  

[v-yueyunzh-msft · Accepted solution]

Hi , @ademooij 

According to your description, your KPI visual show blank .

I test it i n my side , only the "Value" and "Target" are all the blank ,the visual show the blank .

So for this , ou need to make sure that there must be a value for Target in your data. You can try to create a new calculated column or measure to rule out the possibility of null values,like this:

Then the visual will not show the blank in 2022/1//7:

And if you want to replace the blank to 0 , you can also create a measure to add 0 ,like this :
SUM('Table'[Value])+0

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[ademooij]

Hi Aniya,

The calculated column was indeed for me the solution and it works fine now.

Thank you very much!