Forum Discussion
Blank KPIs
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.
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.
12 Replies
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 🙂
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
Syndicate_Admin, are you able to show me the measure and let me know the Data Type? Thanks heaps!
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])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 🙂
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
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.
