Forum Discussion
Stop Visual from refreshing when items are selected from it.
Hi don075 ,
Based on the description, it is impossible to edit interaction to stop the table visual refreshing. Edit interaction has no effect when re-selecting type inside the table visualization, it is not a filters function. Because you select the different column in matrix visual and table visual. The SUM function counts different values for different selected value.
Please try the following method as workaround:
Select the table visual and drag the category1 and category2 to the Filters pane. Set the Basic filtering.
You can view the following document to learn more information.
Filters and highlighting in Power BI reports - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello don075,
To prevent the table visual from refreshing when items within it are selected, go to Format > Edit interactions
Set the Matrix to filter the Table, ensuring the Table itself is set to “None” for all other visuals to prevent reverse filtering.
This will allow focused control over your visuals.
Let me know if you might require any further assistance.
Thanks for the response.
I did the following
Selected Matrix visual and clicked Format
Selected Edit Interaction
Clicked Filter under Table visualSelected Table visual
Selected None under Matrix visual
That didn't fix the issue.Here is a screen shot of the changes.
Also, once this is working, I need to add a third table tha should update when items are selected from the first table visual.
