Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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!

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    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.

2 Replies

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    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.