How to slice data for several columns

[powerbihelp123]

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

Managers	Manager ID
Mike	789
Matt	678
John	234

I have two tables. One table has Managers and their ID. The other main table has all of my data including two columns with the project owner ID and their manager's ID. Sometimes the manager is also a project owner. In Power BI I am trying to set up a lot of data visuals, with a slicer of different manager to show each manager's projects hour contributions. How do I set up the slicer/Power BI so that the ID column from the manager table is connected to both Project owner and Manager in the main table, so that my slicer of managers when one manager is clicked, all the visuals will update so that they contain project info where the manager is project owner as well as the manager's employees under them. 

Right now I have tried to make two relationships, from Manager ID to Manager ID and Manager ID to Project Owner ID, but Power BI only lets one relationship to be active at once. 

[Ashish_Mathur]

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.

[ryan_mayu · Accepted solution]

@powerbihelp123 

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

[powerbihelp123]

Thanks for your help. Would this be possible if Project Owners are a measure that concatenates several different project owners if they have the same project ID? I have a separate measure for that, so was wondering if I could do something like "if contains" or something of that sort. 

[ryan_mayu]

do you mean multiple seleciton or something else? could you pls update the sample data and expected output?

[v-aatheeque]

Hi @powerbihelp123 

I wanted to follow up on your question regarding the possibility of using a measure to concatenate multiple project owners based on the same project ID.

To assist you more effectively, could you please provide the sample data and the expected output? This will help us understand your requirements better and offer a more targeted solution.

Thank you for your cooperation, and I look forward to your response!

[v-aatheeque]

Hi @powerbihelp123 

Just following up on my earlier request for some sample data and the expected output regarding your question about using a measure to concatenate multiple project owners by project ID.

Sharing this information will really help us better understand your scenario and suggest the most suitable solution.

Looking forward to your response.
thank you for your cooperation!