Forum Discussion
Two Slicers Working Independently from One Another?
Hi,
I would appreciate any help with the following:
- I have a single table with a selection of products that are mutually exclusive.
- I would like to create two different slicers with groups of products that work independently and put them on the same page.
- To these, I would like users to be able to apply independent measure slicers to reevaluate the total value of each group based on the impact of a chosen parameter.
The end result should look like the following:
The data in group 1 and group 2 come from the same table. For now, this means that if I select something from the group 1 category of products group 2 will be empty since these groups are mutually exclusive.
My questions are - is there a way to do this in Power BI without splitting my original data table into several other tables?
And is there a way to write some DAX code that will tell PowerBI that when I select group 1 or 2 it should recalculate the total value of the chosen products based on what the user chose in parameter 1 or 2?
Sorry if this sounds a bit basic but I am fairly new to Power BI.
Any help will be greatly appreciated !
2 Replies
- barritown
Solution Sage
Hello LadyCat,
Won't this functionality - https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop - be a solution in your case?
- LadyCatFrequent Visitor
Looks like it, thank you! Sorry for the newbie question ...