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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Gronga
New Member

No solution yet...

I have the following problem:

 

I have a record with order numbers and various other details such as production date, work area (No. 1-10) etc. in a table 1 (not a matrix but tables visual)
I filtered this data record because I'm only interested in work areas 1-3. Is there a way to create a second visual table next to it that refers to all order numbers from table 1, but uses different filters?

 

Explanation: In the data record, the order numbers sometimes appear more than once, since they had several production steps and can therefore appear in work areas 1-10 with different production dates. I hope you understand what I mean. The problem in this case is that I can't filter multiple times in a row. I either filter by work area 1-3 or 4-10. Both at the same time does not work and I have not found a solution so far.

 

Thanks a lot!

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

Hi @Gronga ,

 

You may learn about the interaction among visuals.

Change how visuals interact in a report - Power BI | Microsoft Learn

As shown in the following example, the table on the left contains the working area 1-3, and the table on the right cancels the interaction with the left table, and the work area 1 is filtered out separately.

The two table visuals both come from a table.

27.png

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

Hi @Gronga ,

 

You may learn about the interaction among visuals.

Change how visuals interact in a report - Power BI | Microsoft Learn

As shown in the following example, the table on the left contains the working area 1-3, and the table on the right cancels the interaction with the left table, and the work area 1 is filtered out separately.

The two table visuals both come from a table.

27.png

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

yes, you can have different visuals pointing to the same source data using different visual level filters. The moment the user interacts with one of the visuals (say, by clicking on a cell) the other visual may be affected (unless you disable interactions).

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.