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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.