Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
Pfisterbi
Advocate I
Advocate I

Composite Modell - missing value in dimension - not showing blank

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:

Pfisterbi_0-1649944199946.png

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:

Pfisterbi_1-1649944324828.png

The result in a visual looks like this:

Pfisterbi_2-1649944394853.png

 

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

Thx for your help

 

5 REPLIES 5
macmachine
Frequent Visitor

Hi @Pfisterbi , did you ever find an answer to your question? 

I'm in the same situation now... having missing dimensions and working in a mixed model. thanks!

 

v-chenwuz-msft
Community Support
Community Support

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.

Hi @v-chenwuz-msft 

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

Pfisterbi_0-1650438674023.png

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
Memorable Member
Memorable Member

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

Hi @davehus 

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

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.