Slicer Filtering

[Anonymous]

Hi All,

I have 6 tables (measurement and targeted as a pair) appliances targeted and measured, electronics targeted and measured, household targeted and measured, that are connected in powerBI using ODBC. I have made three tables using merge table as new (Household, electronics, appliances). Now i have shown the data in tabular form and bar graph using appliances. And I have created a slicer with three custom options Appliances, household and electronics. Now I want this slicer to change the appliances data in the graph and table to change to household and electronics depending upon the selection made in the slicer. 

Kindly help me out, I have changed the names as the data is highly confidential. Let me know if I didn't provide much clarity. 

thanks a bunch

[v-chuncz-msft]

@Anonymous,

You may take a look at Bookmarks in Power BI.

[Anonymous]

I am constrainted to use only 2017 version. Could please suggest something for that