Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

How to slice data for several columns

Project ID Project Owner Name Project Owner ID Manager Manager ID Project Details A Jeff 123 Mike 789 etc B John 234 Matt 678 etc C Jack 345 John 234 etc   Man...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    Anonymous 

    do not create relationship between two tables.

    create a measure

    Measure = if(max('Table'[Manager])=max(Manager[Managers])||max(Manager[Managers])=max('Table'[Project Owner Name]),1)
    and add this measure to visual filter and set to 1
     
    pls see the attachment below
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

These Power steps will allow you to work with slicers

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Project ID","Project Details"}, "Attribute", "Value"),
    #"Replaced Value" = Table.ReplaceValue(#"Unpivoted Other Columns","Manager","Manager Name",Replacer.ReplaceValue,{"Attribute"}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Replaced Value", "Attribute", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Designation", "Attribute.2"}),
    #"Pivoted Column" = Table.Pivot(#"Split Column by Delimiter", List.Distinct(#"Split Column by Delimiter"[Attribute.2]), "Attribute.2", "Value")
in
    #"Pivoted Column"

Hope this helps.