Forum Discussion

Tyker504's avatar
Tyker504
New Member
2 years ago

Selecting aggregate column on one table sets filter on different table

Hello Everyone,   I am super green to Power Bi (I know DA and SQL to a decent degree) and I am trying to build a report that provides a high level overview (left table), then breaks down the aggreg...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Tyker504 

 

Are you not wanting to filter the right table when you click on the left table? If I understand correctly, you can try the following:

 

1. select the left table first. Then select Format -> Edit interactions

 

2. select "None" in the upper right corner of the right table

 

Output:

 

Best Regards,
Yulia Xu

 

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

Tyker504's avatar
Tyker504
New Member
2 years ago

Not quite. The left table is the main table that breaks down all policies with their completed %. When a use clicks into completed Consents or Incomplete Consents on the left hand side the right hand side filters down to show only the respective (incomplete / complete) status on the right. 

 

 

Clicking Left square will filter the right table to show those two squares.

 

 

but the tip you did provide above will help with that issue šŸ˜€