Forum Discussion

LadyCat's avatar
LadyCat
Frequent Visitor
3 years ago

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 !