Hierarchy data display in slicer or table data

[kmpmuthu]

Hi,

We are using Hierarchy SQL table data in report and it should display like hierarchy format based on below condition.

How can I acheive this?

WHERE (company.Hierarchy.IsDescendantOf(('/700/'))=1)

I want to display Parent child data based on Hierarchy.IsDecendantOf()

1. Parent 1

1. Child 1

2. Child 2

3. Child 3

       1. Child 3-1

       2. Child 3-2

4. Child 4

Thanks in Advance.

[v-lili6-msft · Accepted solution]

hi, @kmpmuthu 

You may try to use HierarchySlicer visual or Matrix visual in power bi.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview

Best Regards,

Lin