Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Remove Nulls

Path 2 = VAR PathLen = PATHLENGTH ( 'Project'[WBS - Copy] ) VAR Delimiter = "." RETURN IF ( PathLen >= 2, 'Project'[Path 1] & Delimiter & PATHITEM ( 'Project'[WB...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ，

    Does your DAX formulae return this result?

    1

    1.1

    (Blank row)
    1.1.1
    (Blank row)

    And is this what you want?

    1

    1.1

    1.1.1
    (Remove the blank rows)

    If yes, you can use 'filter on this visual' when you use the measure in a visual.

     

    Best regards,
    Lionel Chen

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ，

Does your DAX formulae return this result?

1

1.1

(Blank row)
1.1.1
(Blank row)

And is this what you want?

1

1.1

1.1.1
(Remove the blank rows)

If yes, you can use 'filter on this visual' when you use the measure in a visual.

 

Best regards,
Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Unfortunately, I've tried filtering.

    This is my code for using the HierarchysSlicer. 

    Path 1 = 
 PATHITEM('Project'[WBS - Copy],1,TEXT)

Path 2 = 
VAR PathLen =
    PATHLENGTH ( 'Project'[WBS - Copy] )
VAR Delimiter = "."
RETURN
  IF(
        PathLen >=2,
        'Project'[Path 1] & Delimiter
            & PATHITEM ( 'Project'[WBS - Copy], 2, TEXT ),
       BLANK()
    )

Path 3 = 
VAR PathLen =
    PATHLENGTH ( 'Project'[WBS - Copy] )
VAR Delimiter = "."
RETURN
    IF (
        PathLen >=3,
        'Project'[Path 2] & Delimiter
            & PATHITEM ( 'Project'[WBS - Copy], 3, TEXT ),
        BLANK ()
    )
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I meant to say that this is a measure also

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

    Something so simple. There is a Hide Members selection in the Hierarchy Slicer properties.

    Hide Members and voila ... (blank) is gone.