Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

assigning slicers to visualizations

I don’t know if this subject is covered, but is it possible to assign a slicer to a visualization?

I am currently working on comparing sales performance between ‘MyCompany’ items and competitor items and I want to create a comparison based on the features the items provide. I’m accessing the sales information from one data set and created a slicer based on the items related to ‘MyCompany’ and one feature category. The slicer applies to 2 visualizations, one which lists the items associated to ‘MyCompany’ and one which lists the items associated to the competitors. For example, if I select ‘MyCompany CPU Brand’ = BrandA, my output in the ‘MyCompany Item List’ and ‘Competitor Item List’ will show all items where ‘CPU Brand’ = BrandA.

My data set looks like this:

CompanyProduct ModelCPU BrandCPU Model
MyCompanyA85BrandAX3
Rival1B23BrandAX3
Rival1B44BrandAX1
Rival1B75BrandBV3
Rival2C18BrandAX5
    
MyCompanyA66BrandAX5
Rival1B23BrandAX3
Rival1B44BrandAX1
Rival1B99BrandBV6
Rival2C18BrandAX1
    
MyCompanyA77BrandAX7
Rival1B44BrandAX1
Rival1B99BrandBV6
Rival2C18BrandAX1
Rival2C33BrandBV9

 

I am trying to create a slicer that only applies to the competitor item visualization so I can further filter the competitor item list so I can perform feature vs feature comparisons. If I select ‘MyCompany CPU Brand’ = BrandA, the ‘MyCompany Item List’ will reflect the items which have BrandA CPU, it will also apply to the ‘Competitor Company List’ visualization so I can see which items have been matched to the items listed in the ‘MyCompany Item List’ visualization. Then I can select from a 2nd slicer, “Competitor CPU Brand”, and filter the items listed in the “Competitor Item List” to reflect only the items which meet the criteria selected.

3 Replies