Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
cristio
Helper I
Helper I

I can`t find a video anywhere not even Youtube that shows you how to do this?

Hello,

 

I want to create interactions between different tables in POWER BI. I`ve selected that 1 slicer shouldn`t have any interaction with any of the other tables on the Power BI first page, where I have different tables showing data.

 

The problem is, If I want that particular slicer just to interact with 1 table, how do I do that. I went to manage relations and clicked on it multiple times.

 

Once I told it not to have any interaction with any of the other tables, it didn`t switch back to having interactions with other tables. I need after I told it not to have an interaction, to have an interaction, I need to be able to toggle between not having an interaction to having one?


How do you do that? If i choose filter, the whole data from the table disappears, and I can`t get it back.

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

@cristio ,

you should be able to do this by "Edit Interactions" feature.

When you have the slicer highlighted you will see a "Format" pane in the top many and the first button on this page is the one you want. One you enabled "Edit Interactions" some extra icons will apear on the other objects and all object is by default set to filter. You can change the object you don't want to be filtered by the slicer to "None".

refer:

https://sqlskull.com/2020/07/12/edit-interactions-in-power-bi/ 

 

And in my own experience, I often operate by copying the slicer's table, then creating a relationship between the copied table and only the table I want to filter, leaving no relationship between it and the other tables, and then creating the slicer with the fields in the copied table, so that the slicer only affects the visual effect of the filtered table. However, there are some disadvantages in that the fields in the filter table are used in other visuals and other visuals will be filtered as well.And alternatively you can try creating replica tables after replica tables and all tables, deleting relationships, creating MEASURE using replica slicer tables to filter reports.

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

@cristio ,

you should be able to do this by "Edit Interactions" feature.

When you have the slicer highlighted you will see a "Format" pane in the top many and the first button on this page is the one you want. One you enabled "Edit Interactions" some extra icons will apear on the other objects and all object is by default set to filter. You can change the object you don't want to be filtered by the slicer to "None".

refer:

https://sqlskull.com/2020/07/12/edit-interactions-in-power-bi/ 

 

And in my own experience, I often operate by copying the slicer's table, then creating a relationship between the copied table and only the table I want to filter, leaving no relationship between it and the other tables, and then creating the slicer with the fields in the copied table, so that the slicer only affects the visual effect of the filtered table. However, there are some disadvantages in that the fields in the filter table are used in other visuals and other visuals will be filtered as well.And alternatively you can try creating replica tables after replica tables and all tables, deleting relationships, creating MEASURE using replica slicer tables to filter reports.

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

MahyarTF
Memorable Member
Memorable Member

Hi,

Not sure what do you mean, 

But for creating the Slicer based on the different items from separate tables you could use the Field Parameter in Power BI :
https://www.youtube.com/watch?v=VTr1a0yknTo

Hope it will be useful for you 

Mahyartf

I want to connect 2 tables so that when i click one item in one table, the other table has changed. And I want this option to be available and active and I want this option to be deactivated. I want to toggle between activated and unactivated

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.