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?
