Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

HierarchySlicer

Hi I am new in PowerBI and Power Pivot  I create a  4 columns  for  Hierarchy  product leverl  from level 1 to level 4 . I try to use HierarchySlicer. It works but I  notice  the product is dupicat...
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Bhavesh

This is the  one of Catalgory . I  build by PowerPivot

The max level is  only 4 . However some Catalgory may be less than 4 level even only 1 level .

Thank-you  for your help

Kenneth

BhaveshPatel's avatar
BhaveshPatel
Super User
10 years ago

Hi Kenneth,

 

From looking at your data, You need to create Parent Child Hierarchies in Your case to correctly see all the levels in your slicer.

 

The below blog by Wise Owl have an excellent information on how to create such type of hierarchies in your data.

 

http://www.wiseowl.co.uk/blog/s2479/parent-child-hierarchy.htm

If you get stuck, let me know. Happy to show you a demo.

 

Thanks & Regards,

Bhavesh