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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
MichaelNewHouse
New Member

Value with empty dimension show only in total

Hello Everyone,

 

I have a matrix struggle when a dimension is empty but it must have to be empty.

 

This is my product hierarchy

Képernyőkép 2023-09-11 143214.png

That means that only the main products have the full category dimensions. The Complementary products compatible with more than one main product so these articles could not be classifies like the main ones.

 

I need to make a matrix visual like that:

Képernyőkép 2023-09-11 143810.png

But now I get this:

Képernyőkép 2023-09-11 144021.png

How can I make a matrix visualization like that?

 

Thanks in advance,

Michael

 

 

 

0 REPLIES 0

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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