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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.