Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Hierarchy Slicer

Hi Friends   Can you please help me on slicer hierarchy.   If i select parent hierarchy , the child field should not select, only parent related value should display.   Thanks Sivagari
Need Help
  • v-viig's avatar
    v-viig
    7 years ago

    jppp (developer) to help in resolving this issue.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

jppp's avatar
jppp
Continued Contributor
7 years ago

Hi PhillieB69 

 

The HierachySlicer works best for the scenario that a parent is an attribute of a child, so if we are looking at  a table the parent and child are 'just' columns with a sales figure. Or the sales of the parent is the sum of the children, the same is related to the way the selection is working.

 

If you have parent self have sales, the easiest way is to repeat that the parent attribute also in the child column.

 

Region  Country

EMEA    EMEA

EMEA    France

EMEA    Germany

 

-JP

PhillieB69's avatar
PhillieB69
Frequent Visitor
7 years ago

Hi JP,

 

Thanks for the quick reply. Repeating the parent attribute would is indeed the solution we are currently looking at.  The only minor downside would be to see the attribute duplicated, but functionally it will  provide the rigth info. But good to know I am not overseeing any functionality :)

 

Thanks!