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

kintela's avatar
kintela
Helper II
9 years ago

Hi

 

Now I don´t understand why if I have this

 

 

When I put the fileds in my report I have this

 

 

But If I select the Hierarchy Slicer Visual I have this

 

 

All that BLANKs??????

 

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