Filter dimension values based on User selection

[AaaaD1]

There are 2 table with no relation (created based on requirement).
first with 2 values User and Team, second with data distributed on tool with either User and teams , not all tools have User data but all tools have teams data. there is a column that determines this tools have no. of user or no. of teams(like below) .

Tool    type      usernames                  teams

  A       user     distinct usernames    distinct teamnames

  B       team                                      distinct teamnames

  c       user      distinct usernames    distinct teamnames

  D     team                                        distinct teamnames

Now we have a slicer from Table one for User or Team selection where if User is selected then charts reflect data only for tools that have user data and if teams is selected then all the tools data is shown. this works fine with charts as its more of change in measure and in measure we can add filters.
My problem is with slicer where i want to show tools based on selection if user is selected from table one then show only tools where user data is present and if Tool is selected then show all the tools for selection in the slicer 

[v-yiruan-msft]

Hi @AaaaD1 ,

If I understand correctly, it seems that you want to show the tools on the slicer base on the selected type. Am I right? If yes, you can refer the following links to get it:

Solved: Filter slicer based on other slicer selection - Microsoft Fabric Community

Solved: Change Slicer option based on other Slicer - Microsoft Fabric Community

Filter One Slicer Based on Another Slicer in Power BI - Excelerator BI

Best Regards

[AaaaD1 · Accepted solution]

Hi @v-yiruan-msft 

Thanks for the reply!

i was trying to acheive it with the ways it works in other BI Tool.

i didn't had relation between these 2 table wanted to acheive something like if( selection in Table1(field) =User, Table2[show tool only with User data](Filtered tools column) , Table2[show all tools]

Made some data model changes and got the solution.

Created NewTable1 with 2 column, Type and tool name from Table2.

         - First added tools with only user data and type-User

         - added all tools with type- Team

Created relation based on Tool column between NewTable1 and Table2 

[v-yiruan-msft]

Hi @AaaaD1 ,

It's glad to hear that you got the solution. And thanks for sharing your solution here. Could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours.  Thank you.

Best Regards