parent-chield recursively

[kintela]

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

[v-ljerr-msft · Accepted solution]

Hi @kintela,

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

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

Regards

[v-ljerr-msft · Accepted solution]

Hi @kintela,

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

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

Regards

[kintela]

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 · Accepted solution]

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.

Regards

[kintela]

Done Thanks