Forum Discussion

kintela's avatar
kintela
Helper II
9 years ago
Solved

parent-chield recursively

Hi I have a parent-child hierarchy in my table and I si the paths without problems   But when I try to show the name of the fase not the code they don't appear   Any idea please? re...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi kintela,

     

    Could you try the formula below to see if it works?:smileyhappy:

     

    Nivel1 =
VAR currentPath =
    PATHITEM ( [Path], 2, 0 )
RETURN
    CALCULATE ( LOOKUPVALUE ( Fases[Fase], Fases[ID], currentPath ), ALL ( Fases ) )

     

     

    Regards

  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi kintela,

     

    This may be the default behavior for the Hierarchy Slicer custom visual currently that all blanks in the columns will also be shown up on the slicer. And I don't think there is an option to disable it.

     

    In this scenario, I would suggest you to contact the author and give your feedback to improve the Hierarchy Slicer custom visual.:smileyhappy:

     

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi kintela,

 

This may be the default behavior for the Hierarchy Slicer custom visual currently that all blanks in the columns will also be shown up on the slicer. And I don't think there is an option to disable it.

 

In this scenario, I would suggest you to contact the author and give your feedback to improve the Hierarchy Slicer custom visual.:smileyhappy:

 

 

Regards

kintela's avatar
kintela
Helper II
9 years ago

Done Thanks