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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
dev85
Frequent Visitor

Matrix drilled data issue

Hello guys

 

I've created the next matrix:

dev85_0-1661975839623.png

That matrix is composed between 2 tables: Issues and tasks. All tasks must have a parent issue, however not all issues have a task attached to it. My question is, right now the matrix it is only showing the issues that have a task related (the ones in which you can click on the + to see the tasks related),  is there a way for the matrix to show all the issues, even the ones that does not have a task assigned? 

 

 

1 ACCEPTED SOLUTION
jgeddes
Super User
Super User

Assuming that the Doing | Done | To Do columns are calculated values driven by tasks you should be able to right click on the Issue field and select "Show items with no data".

jgeddes_0-1661977800253.pngjgeddes_1-1661977816398.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
jgeddes
Super User
Super User

Assuming that the Doing | Done | To Do columns are calculated values driven by tasks you should be able to right click on the Issue field and select "Show items with no data".

jgeddes_0-1661977800253.pngjgeddes_1-1661977816398.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





dev85
Frequent Visitor

Hi @jgeddes 

 

OMG it was as easy as that!!! You can not believe the turns I was thinking to fix this. Thanks

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.