Forum Discussion

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?

regards

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
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

4 Replies

v-ljerr-msft
Microsoft Employee
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
- 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
    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

Related content