Bar chart showing (blank) but matrix show nothing for unmapped dimension table column

[NCS_WoongJinKai]

For example, I have a fact table and dimension table with relationship. When I create a bar chart, the unmapped column will show (Blank) but on matrix it shows nothing (empty text). How can i modify the matrix so they show as (Blank) as well for consistency?

[Bibiano_Geraldo]

Hi @NCS_WoongJinKai ,
Create a new Dim calculated column to replace empty values with "Blank" by this DAX:

Column = 
IF(
    ISBLANK('Table'[Dim]),
    "Blank",
    'Table'[Dim]
)

Now in your rows in Matrix, use this column to display values.

[shafiz_p]

Hi @NCS_WoongJinKai  I think it is default mechanism of table and other visuals. If you need blank() text instead of blank, you need to create a seperate table which combines distinct id from both table and relevent dimention. Then non matching will be tagged as "Blank()". This is showing meaning your data table have different IDs then your dimention table. You could use power query to append and merge and then create a new dimention table with blank are replaced by text "Blank()".

Also, you could use measure and then hide original column with empty column name, font color etc.

In dax, you could follow below steps to achieve this.


For example,
I have 2 tables, Category and Data. One to many relationship. See image:

Create a new table with the below code:

NewCat = 
VAR _table =
DISTINCT(
    UNION(
        DISTINCT(Data[ID]),
        DISTINCT(Category[ID])
    )
)

RETURN
ADDCOLUMNS(
    _table,
    "Category", 
    IF(
        ISBLANK(LOOKUPVALUE(Category[Category], Category[ID], [ID])),
        "(Blank)",
        LOOKUPVALUE(Category[Category], Category[ID], [ID])
    )
)

Create new relationship:

You are done. Use column from Newly create table. See output:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[NCS_WoongJinKai]

I actually know workaround. So what I can said here is that we need Microsoft to be more consistent in this case. Display (blank) across all visual for unmapped dimension table instead some display (blank) and some display empty string in other visuals. Such simple feature should not need a workaround to make it work. Thanks.

[Anonymous]

Hi @NCS_WoongJinKai ,

If you would like to suggest feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Community Support Team_ Scott Chang

[NCS_WoongJinKai · Accepted solution]

Seems like only matrix and table having this issue and other visuals are displaying (blank)

[NCS_WoongJinKai]

This is not the correct way and will looks something like below. So there is no configuration for matrix to display (blank) just like the bar chart or configure bar chart to display as empty string?

[shashidhar]

To ensure consistency in your Power BI report so that the matrix visual also displays (Blank) instead of empty text, you can create a calculated column or a measure to handle the blank values explicitly. Here's how you can do it:

Using a Measure

1. Create a new measure in your data model. Replace YourColumn with the relevant column name.
   DisplayColumn =
   IF(
   ISBLANK(SELECTEDVALUE('DimensionTable'[YourColumn])),
   "(Blank)",
   SELECTEDVALUE('DimensionTable'[YourColumn])
   )
   
   

2. This measure replaces blank values with the text (Blank) while displaying actual values otherwise.

3. Use this measure in your matrix visual instead of the original column.