No solution yet...

[Gronga]

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!

[v-stephen-msft · Accepted solution]

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.

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]

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).