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

WebDataRocks Team WebDataRocks June 5, 2019

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.
WebDataRocks Team

Luis June 6, 2019

Can you show me how to remove (blank) from the filter option

WebDataRocks Team WebDataRocks June 6, 2019

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.
WebDataRocks Team