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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 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.