Blank Selection in Powerbi

[vipul_k]

Hi,

I want to show blank selection in slicer in my PowerBI dashboard. When user selects this blank, all the table and charts must show blank values? Is there a way to do that without adding it in the raw data?

[Anonymous]

@vipul_k - You'll need to add a row in your table to do that. You could add it to your raw data, or you accomplish this with Append in Power Query. To do the latter:

1. Add a new query with a single row to specifying the blank value.

      a. Don't use the name "(Blank)" - in Power BI, that means that the Attribute is unknown, not that there are no rows of data.

2. Select your original query, and click Append Queries.

[vipul_k]

Do I need to create table with blank row in it and then append it using append queries?

[Anonymous]

The basic answer is yes, but how you want to format that row depends on how your model is structured - is this attribute from a separate dimension table, or included in the same table as the numeric values?

-If it's a dimension table, then you could give each attribute the same name, like *Do Not Show*. This row won't be related to any rows in your fact table(s), so no data will appear.

-If it's within the fact table, then you can add a row with *Do Not Show* in each attribute name, and NULL for the numeric values. This row will exist in the fact table, but will not have any values, so no data will appear.