How to remove/hide lower levels on a WBS hierarchy (re-post)

[BI_Learner]

Hi, I am looking for help on how to hide or remove blank levels of the work breakdown structure (WBS) on a matrix report. I created a hierarchy for a construction project that has a four-level WBS. I built a matrix report using this hierarchy to show actual numbers compared against the budget.

The problem is the matrix report shows the lower levels (levels 3 and 4 for example) for some sections of the WBS eventhough they don't exist. I have done research online and tried everything I can think of, but I haven't been able to fix it. Any guidance would be greatly appreciated!

Below are images of the WBS table and the report. Thank you so much.

[anandraman]

Did you tried filtering out the NULLs from all levels of WBS hierarchy in report side?  

Lets Say you have 3 levels Level1, Level2,Leve3

When  you create a report fro this Hierarchy, all the columns of the hierarchy also appar in Visual Level Filter. Add filter there that Level 1 is not blank.. 

Level 2 is not blank.. 

Level 3 is not blank.. 

I hope this should filter out your  NULL WBS.

[BI_Learner]

Hi anandraman,

Thank you for the suggestion. I tried it, but it changed the totals. See image below.

[v-ljerr-msft]

Hi @BI_Learner,

Could you share a sample pbix (with just some mock data) which can reproduce the issue, so that we can better assist on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[BI_Learner]

Hello v-ljerr-msft,

Thank you for the reponse and sorry for the late reply. I had to go through an internal process before I can share the file. Here is the link to the pbix on Onedrive.

https://sempraglobal-my.sharepoint.com/personal/vdang_sempraglobal_com/_layouts/15/guestaccess.aspx?...

Best regards