cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pfisterbi
Helper I
Helper 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

 

4 REPLIES 4
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
Super User
Super User

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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors