Blank Label in Matrix Row

[dday9]

I have a data table named ResourceDocuments with a nullable foreign key column named ResourceDocumentStatusId that references the ResourceDocumentStatuses table.

In Power BI I've created a new matrix where the Row is the ResourceDocumentStatuses.Name and the Value is the count of a new column created in Power BI with the following expression:

CreatedOnLastWeek = (
    IF(WEEKNUM(ResourceDocuments[CreatedOn]) = WEEKNUM(TODAY()) - 1, 1, BLANK())
)

Where I'm running into an issue with is if there is a row in the ResourceDocuments and its ResourceDocumentStatusId is null, it is displaying a blank label for the row name (not "blank" but literally an empty String); see image below.

Is there a way to provide a custom label for this blank row name?

[HKInd]

Hope you have tried filter pane or Visual level filter by picking metric column and droping in filter pane and check all and uncheck blank.

[dday9]

To be honest, I do not remember what I did. All I know is that I'm glad that I'm not on Power BI anymore and just back to raw SQL.

[trapti]

Correct but what to do if the same problem occurs in excel?

[dday9]

You realize that this thread is over 4 years old and not even remotely related to Excel, right?

[v-juanli-msft]

Hi @dday9 

You want to replace the blank row with a new name, right?

It seems impossible.

You could filter out the blank row.

Please find the reasons and workarounds for this case below:

https://community.powerbi.com/t5/Desktop/How-to-rename-a-blank-value-in-a-matrix-row-or-column/td-p/...

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.