Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Direct and Indirect Report

Hello PowerBi Community.. I am new to this tool and thought could get your help and expertise with Direct and Indirect reports. I found quite a few links on this topic but could not help achieve what...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

     

     

     

     

    The only problem is I am seeing the blank when I expand the tree. Is there a way to remove the blank from the visual?

     

     

     

     

    Not unless you want to go to extremes with ISINSCOPE, or are willing to use the hierarchy slicer visuals that traverse the tree for you.  With your hierarchy size that will already incur a meaningful time penalty.

     

    Note that you don't need to do that much of a cleanup.

     

     

     

     

    let
    Source = Csv.Document(File.Contents("C:\Users\xxx\Downloads\Hierarchy data.csv"),[Delimiter=",", Columns=4, Encoding=65001, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Replaced Value" = Table.ReplaceValue(#"Promoted Headers","",null,Replacer.ReplaceValue,{"LEADER_ID"})
in
    #"Replaced Value"

     

     

     

    And SELECTEDVALUE makes little sense in calculated columns. Streamline your data.

     

     

     

    level_2_NAME = var e = PATHITEM([path],2) return MAXX(FILTER(ADM,[EMPLID]=e),[NAME])

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hello lbendlin,

Thank you! I have organized the data and added the path function. I am trying to use Matrix/slixer visual to see the org chart. The only problem is I am seeing the blank when I expand the tree. Is there a way to remove the blank from the visual? Attached is the copy of the Power Bi report and the source data.https://drive.google.com/drive/folders/1335DTWOxzHtXj8CplBzFffEwYyib0Pye?usp=sharing  

lbendlin's avatar
lbendlin
Super User
1 year ago

 

 

 

 

The only problem is I am seeing the blank when I expand the tree. Is there a way to remove the blank from the visual?

 

 

 

 

Not unless you want to go to extremes with ISINSCOPE, or are willing to use the hierarchy slicer visuals that traverse the tree for you.  With your hierarchy size that will already incur a meaningful time penalty.

 

Note that you don't need to do that much of a cleanup.

 

 

 

 

let
    Source = Csv.Document(File.Contents("C:\Users\xxx\Downloads\Hierarchy data.csv"),[Delimiter=",", Columns=4, Encoding=65001, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Replaced Value" = Table.ReplaceValue(#"Promoted Headers","",null,Replacer.ReplaceValue,{"LEADER_ID"})
in
    #"Replaced Value"

 

 

 

And SELECTEDVALUE makes little sense in calculated columns. Streamline your data.

 

 

 

level_2_NAME = var e = PATHITEM([path],2) return MAXX(FILTER(ADM,[EMPLID]=e),[NAME])