NEED HELP IN POWER BI

Hi sarath_chandra ,

You can add the visual you need from App Source. In Power BI Desktop click on "Get more visuals" and search for one of:

• Hierarchy Chart by MAQ Software

• swOrgChart

• Hierarchy Chart by Akvelon

• TreeViz

• Ultimate Decomposition Tree

Add custom visual

While with Hierarchy Chart by MAQ Software, swOrgChart, and Hierarchy Chart by Akvelon you can use your PK and CK columns as they are, with TreeViz and Ultimate Decomposition Tree you need to create columns per category (e.g. manager, team lead, implementer, ...) first in your table.

For each visual you can download a sample file so you can choose your preferred option.

BR

Martin

Referring to your table in message 1, in order to build the slicer you need:

1. A disconnected table (i.e. a table that has no relationship in the data model) with a distinct list of your parent nodes. This DAX code creates this table:
   DAX code for a new table:
   
   Slicer Values = SUMMARIZECOLUMNS ( 'Table'[PK] )
2. A measure to be used to select the complete branch below the top node that you want to select in the slicer:
   DAX code for a new measure:
   Show Node =

   VAR _TopNode = SELECTEDVALUE ('Slicer Values'[PK] )

   VAR _CurrentNodePath = SELECTEDVALUE ( 'Table'[Path] )

   RETURN

   IF (

       OR (

           NOT ( ISFILTERED ( 'Slicer Values' ) ),

           PATHCONTAINS( _CurrentNodePath, _TopNode )

       ),

       "show"

   )
3.  Apply the new measure as a filter to your preferred visual for showing the hierarchy like this:
   Apply visual level filter using measure

With Hierarchy Chart by MAQ Software as an example, the solution bahaves like this:

No parent node selected in the slicer:
No filter

A parent node selcted:
A filter set

A different parent node selected:

A different filter set