Forum Discussion
Limiting Slicers' Scope
Hi Budfudder,
Believe that when you talk about first row and second row you are talking about visual right and not rows in a table.
You should use the interactions between visuals check this documentation where you can see how to make some visuals interact with other or not, this is made from one visual to the other, so in your case you should select the slicer and then on the other visuals select if it filters or not the results.
Regards,
MFelix
Thanks for your response - unfortunately I don't understand your solution.
In my situation, I have a table where each row is a sale. Each row contains the sale's stage and the sale's territory. I want to show:
- a visual of a clustered column chart showing a count of ALL sales by sales stage and
- another visual of a clustered column chart showing a count of just each territory's sales by sales stage.
So I created a slicer to slice by territory - the problem is that it affects both of those visuals.
I don't understand enough of your solution to know how I would apply it to my situation, where there is only one table, and each row has:
| ID | Stage | Territory |
And by the way, how did you create that table in your post?
Now you better examplined what your looking for it may be besat to learn a little more about Power BI and follow MFelix's advice.
This might be a little advanced but you may be able to figure it out or I'll include it for posterity. If you wanted to show the results in the same visual and and wanted to use my solution you would just make two disconnected slicers and dont' link them to your table. You create can create the tables using "Enter Data" from main ribbon or form the Edit Query window use Power Query to create a copy of your data table, remove the other columsn excep "Territory" and then remove duplicates. Then you set your slicer on that table and don't link it to your data table. You then need to write two measures and use && in the calculate to filter on both Territory and Region.