Blank KPIs

[Syndicate_Admin]

Hello everyone

This is my first post.

I have a KPI that provides data from a date and target from an earlier date. The fact is that when there is no data I get a text that says "blank" and I want to change it for another, for example "-" a simple hyphen (or change the font size only in the case that it is blank). I have created new measurements and used in dax to create variable with the ISBLANK function but there is no way I will change the text. With the new measure created and in a simple results card if the change appears, but in the KPI no. Thank you very much in advance.

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

The data is affiliated to the SS and is quite a few records and I want to make a kpi with current value and difference previous month. Maybe it's not possible. Shooting of a very large excel with several fields and many records.

According to the official document, the sample is used KPI visual to compare Current Month and Last Month. And I tried to create measures to reproduce your issue —— when value is blank then set to 0, it works as well on my side.

Measure 2 = IF([Measure]=BLANK(),0,[Measure])

Or you may try add +0  to your measure to directly change blank to 0

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

[Syndicate_Admin]

In the kpi I get a warning symbol that says "There are too many 'Date' values. Not all data is displayed. Filter the data or choose another field" I guess that's the cause

The data is affiliated to the SS and is quite a few records and I want to make a kpi with current value and difference previous month. Maybe it's not possible. Shooting of a very large excel with several fields and many records.

Thank you

The measure:

Total White Affiliates =

IF(ISBLANK([Total Affiliates]),

"No data",

[Total Affiliates])

[TheoC]

Hi @Syndicate_Admin, found the cause and a solution in an older post:

https://community.powerbi.com/t5/Desktop/KPI-Indicator-Showing-quot-BLANK-quot/m-p/202591

Hope this helps 🙂

[TheoC]

@Syndicate_Admin, if for some reason that doesn't work, Reza has broken down a detailed solution specifically for this here:

https://radacad.com/replace-blank-with-zero-in-power-bi-visuals-such-as-card

[TheoC]

@Syndicate_Admin you can resolve by wrapping your measure in the following:

MeasureName = 

IF ( ISBLANK ( [measure] ) , 0 , [Measure] )

The output will be 0 but you can change the 0 to "-". I'd recommend the 0 however.

Other options include:

Measure = IF ( [Measure] = 0 , 0 , [Measure] )

And finally, although I don't recommend due to some limitations if you want to expand on the measure is simply adding a +0 at the end of your existing measure.

Hope it helps 🙂

[Syndicate_Admin]

Thank you, I do that but it does not change me, it continues to appear "blank" in the kpi, instead in the result card if it goes well, and I need it for the kpi

[TheoC]

@Syndicate_Admin, are you able to show me the measure and let me know the Data Type? Thanks heaps!

[TheoC]

@Syndicate_Admin try the following please:

Measure = IF(ISBLANK([Measure]),BLANK(),IF(ISBLANK([Measure]),0,[Measure])

The issue that may be causing the blank is that there may be blanks in your outputs that are valid blanks and therefore it's testing to see if a blank exists, if it does, convert to 0, otherwise deliver the output of the measure.  

Hope this helps

[Syndicate_Admin]

With this measure, I still come out "blank", but with the explanation you have given me if I can add that for that time filter there is no data, that is, it is not that they are not blank but that there is no data in the source.

From the link he offered me I can not find a simile.

Thank you very much anyway

[TheoC]

@Syndicate_Admin, yes. You're correct. Basically, the cause is that there are blanks in the column your using for the measure. If you can create a new Calculated Column that converts your blank data into a value, such as 0, then perform the measure on the new column,  it should fix the issue. Alternatively, you could use the Filter pane on the KPI visual and select all and leave Blank unselected. Either option should eliminate the blanks and your KPI measure won't be taking blanks into consideration. 

I hope this helps and apologies I couldn't be more help if it doesn't resolve the problem. 

Best of luck!

Theo 🙏 

[Syndicate_Admin]

Don't worry you've been of great help. I have created a record in the database with the date that had no values and with zero value, and now it appears like this, as zero "0". It is a possible solution, I look to see if I can change it for a text and if not, so I can escape.

Thanks a lot

[TheoC]

@Syndicate_Admin all the best my friend.