Forum Discussion
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:
| Company | Product Model | CPU Brand | CPU Model |
| MyCompany | A85 | BrandA | X3 |
| Rival1 | B23 | BrandA | X3 |
| Rival1 | B44 | BrandA | X1 |
| Rival1 | B75 | BrandB | V3 |
| Rival2 | C18 | BrandA | X5 |
| MyCompany | A66 | BrandA | X5 |
| Rival1 | B23 | BrandA | X3 |
| Rival1 | B44 | BrandA | X1 |
| Rival1 | B99 | BrandB | V6 |
| Rival2 | C18 | BrandA | X1 |
| MyCompany | A77 | BrandA | X7 |
| Rival1 | B44 | BrandA | X1 |
| Rival1 | B99 | BrandB | V6 |
| Rival2 | C18 | BrandA | X1 |
| Rival2 | C33 | BrandB | V9 |
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
- amitchandak
Super User
Have you already tried Interactions to deal with this.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin - mwegener
Most Valuable Professional
Hi Anonymous ,
look at this.
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support. - mwegener
Most Valuable Professional
Hi Anonymous ,
is your problem solved?
If we answered your question, please mark a post as solution, this will also help others.
Please give Kudos for support.