Composite Modell - missing value in dimension - not showing blank

[Pfisterbi]

Hi there

In Import Mode, there will always be shown a blank row for missing values in a dimension.
In a composite modell, this seems not to be working.

For example, I have a dimension with just one entry:

The dimension has been published into the service.

Then I created a new pbix, imported the fact tables and used the dimension as a shared dataset.

The fact table looks like this:

The result in a visual looks like this:

Why does this happen? And how may the problem be resolved?

Thx for your help

[v-chenwuz-msft]

Hi @Pfisterbi ,

Did you create a relationship between these table based on ID? Or please make the relationship active.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pfisterbi]

Hi @v-chenwuz-msft 

Relationship is set.
See picture of the modell with data included.

While working in a full import mode, DimID 2 is shown as blank.
But in mixed mode (Dimension as shared dataset), DimID 2 is missing.

Thx for your help.

[davehus]

Hi @Pfisterbi, if you right click on the field in the visual. Does it give you the option to show items with no data? 

[Pfisterbi]

Hi @davehus 

Yes,but it does not solve the issue, as this feature only works for dimension attributes without a corresponding fact record.