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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
JosueAbreu
Frequent Visitor

matrix with/without "show items with no data"

Hi,

I have a trouble:

I need a matrix with 2 columns:

 

-In column "No_" i want to see rows with no data. I need that to see rows in column No_ for wich we don't have "Soma de Amount (LCY)"

-In column Requalification Date i don't wanna to see "items with no data" because this option shows for me every date in my datadabase.

Sem título.png

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Unfortunately that switch affects the entire bank of row or column fields. 

 

You will need to use a disconnected table to selectively show the items with no data that way.

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Unfortunately that switch affects the entire bank of row or column fields. 

 

You will need to use a disconnected table to selectively show the items with no data that way.

Thanks, Ibendlin.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.