cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
creynolds Member
Member

Values Adjust Based on Filter

I have a Dashboard with 10 individual tables (accessing the same source file).    I am looking for a way that when I select a field within one of the tables, that all tables adjust to that value AND the totals and percentages change based on what I have selected.   As an example, I am on Zappo's website, the site displays 1,000 shoes, I filter on Women's shoes, the screen readjust to only show Women's shoes (100% of the shoes shown are now women's shoes; value is now 500 shoes); now I filter again to only see gym shoes, again the entire screen adjusts to display all women's gym shoes (100% of the shoes shown on the screen are now women's gym shoes, total # of shoes is now 200).   As I continue to filter, I want the values to readjust to be specific to the selected filters; always maintaining 100% focus of what I last selected.    Can PowerBI do this?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Values Adjust Based on Filter

Hi @creynolds

 

By default, Power BI visuals interact each other, which menas any filter applied in one visual will filter other visuals accordingly in the full screen. You need to make sure the relationship and cross filter direction are set correctly.

 

Thanks

Raj

 

1 REPLY 1
Highlighted
Super User
Super User

Re: Values Adjust Based on Filter

Hi @creynolds

 

By default, Power BI visuals interact each other, which menas any filter applied in one visual will filter other visuals accordingly in the full screen. You need to make sure the relationship and cross filter direction are set correctly.

 

Thanks

Raj