cancel
Showing results for 
Search instead for 
Did you mean: 
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
Microsoft
Microsoft

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

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

 

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

View solution in original post

Done Thanks

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.