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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
JCS
Frequent Visitor

Matrix Visual Not Displaying Department Name

Hello,

Issue: I have a matrix where the individual columns do not equal the total amount on the matrix. The issue is occurring when there is no Department associated with a Project.

Details: The matrix is pulling from three tables:

  • Project Department – Market Name field pulled from this table.
  • Project – the Project Name field is pulled from this table and is a drill-down on the Matrix
  • Daily Log Manpower – There is a measure for hours which is pulled from this table and displayed as "Total Manhours" on the matrix.

Again, the reason for the difference (between the line items and the total on the matrix) is that the projects, which have no department value, are not showing up as a row on the matrix. Tried selecting “Show Items with No Value” option on the matrix, but this doesn’t resolve the issue. I have also tried adding a “… + 0” to the measure which shows the hours, but this also doesn’t resolve the issue. It feels like I perhaps need to create a measure for Department Name, which assigns a value, such as “No Assigned Department”, in order for the department-less hours to show up on the matrix, but not sure how to do this?

 

JCS_1-1683812495147.png

 

 

1 REPLY 1
BiNavPete
Resolver III
Resolver III

Hi @JCS 

Without a PBIX this is difficult for me to fix but there is fantastic video on the subject here.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!

Pete
Web: https://binavigation.com
Linked In: https://www.linkedin.com/in/pete-smith-955b73181





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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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