Is there a way to change a KPI from showing “No data” so that is just left blank or has a dash?
Hi
you can try this.
E.g ifelse(isNull({sales}), “-”, {sales})
This will replace null values with a dash (-).
Hi @katep - This is a default behavior and I doubt you may not change it.
Hi @DylanM - Any expert suggestion on this.
Regards - Sanjeeb
1 Like
Thank you. I have just come up with a workaround. I have made the font colour for the KPI the same as the background colour then used conditional formatting to change the colour to black if equal to or greater than 0. So effectively if the result is No data then this is not visible as it shows as the same colour as the background.
2 Likes
Hello @katep, thank you for following up with the work-around solution you were able to implement! I know this is functionality that other users will be happy to implement in their dashboards as well.
I need to urgently be able to change the ‘No Data’ text to read something like ‘No Purchases’. This feature would be an essential change!
Hello @georgeAWS4, for now you could utilize a calculated field like coalesce to replace NULL values with a string value like ‘No Purchases’. That will at least work if your field is a string field and not an integer.
If you have further questions, please post a new topic in the community. That will ensure you are at the top of the priority list for a response from one of our QuickSight experts. Thank you!