How to create hierarchy based on column values - then show other columns within it

[Charlotte_1234]

Hi 
I have a table similar to this (its longer but the layout is similar)

Name	Number	No. Of Visits	Level1Name	Level2Name	Level3Name
Test	1	3	Test	null	null
Test Nested	1.1	2	Test	Test Nested	null
Test 2	2	9	Test 2	null	null
Test 2 Nested	2.1	3	Test 2	Test 2 Nested	null
Test 2 Sub-Nest	2.1.1	5	Test 2	Test 2 Nested	Test 2 Sub-Nest
Test 2 Sub-Nest 2	2.1.2	8	Test 2	Test 2 Nested	Test 2 Sub-Nest 2

I've managed to get it to display in a Matrix sort of, but there are blank nested items which are obvs generated from the nulls in Level2Name and Level3Name.

Is there a way to get rid of these Blank Values?  I have already set the rows to not show blank data but that hasnt done anything, and any measure I have tried seems to over filter and remove anything that doesnt have a Level3Name?

Also, when I add the No. of Visit column I want the value to show next to each item, but it seems to skew onto a blank row which isnt what I'm after (see the screenshot below).

This data comes from a Microsoft Project export and my user wants it to look similar with the nested items etc.

Any help on this would be much appreciated.

[mickey64 · Accepted solution]

For your reference.

[Charlotte_1234]

Thanks Mickey64 - worked perfectly!

[Natarajan_M]

Hi @Charlotte_1234 

You can create hierarchies using the custom hierarchies .

https://learn.microsoft.com/en-us/analysis-services/tabular-models/create-and-manage-hierarchies-ssa...

Right click on the column -> create hierarchy -> adding the first level (Highest level) -> second level-? goes on 

Create hierarchies 

Year hierarchy :

Thanks 
If you found this helpful, please consider giving it a kudo and marking it as the accepted solution — it goes a long way in helping others facing the same issue.

For more Power BI tips and discussions, let’s connect on LinkedIn:
https://www.linkedin.com/in/natarajan-manivasagan

Cheers!