Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kintela
Helper II
Helper II

parent-chield recursively

Hi

I have a parent-child hierarchy in my table and I si the paths without problems

captura.jpg

 

But when I try to show the name of the fase not the code they don't appear

 

captura.jpg

Any idea please?

regards

 

 

2 ACCEPTED SOLUTIONS
v-ljerr-msft
Employee
Employee

Hi @kintela,

 

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

 

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

 

 

Regards

View solution in original post

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.Smiley Happy

 

contact.PNG

 

Regards

View solution in original post

4 REPLIES 4
v-ljerr-msft
Employee
Employee

Hi @kintela,

 

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

 

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

 

 

Regards

Hi

 

Now I don´t understand why if I have this

 

captura.jpg

 

When I put the fileds in my report I have this

 

captura.jpg

 

But If I select the Hierarchy Slicer Visual I have this

 

captura.jpg

 

All that BLANKs??????

 

regards

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.Smiley Happy

 

contact.PNG

 

Regards

Done Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.