How to remove "(blank)"
Good day to you. How do I remove the “(blank)” word if the field is empty or has no value?
3 answers
Hello Luis,
Thank you for the question.
You can use localization options to rename (blank)
to something else, or you can use filter to remove (blank)
values from the slice.
Please let us know if you have any questions.
Regards,
WebDataRocks Team
Can you show me how to remove (blank) from the filter option
Hi Luis,
Here is how you can remove (blank)
members by using the UI filter control:
Please note that you can always save every change you applied via the UI by saving the report and loading it into the pivot table later.
Another way is to apply filtering to the hierarchy by writing the following code:
{ "uniqueName": "Product Category", "filter": { "members": [ "Product Category." ], "negation": true } }
In such a case, the blank members will not be shown on the grid.
Please check the CodePen demo which shows how to apply filtering.
Hope this is helpful.
Regards,
WebDataRocks Team