Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Merge selection from two slicers

Hello to all,  I am puzzled by one task and will be very glad if you could give a hint.    For simplification of the situation, let's have two tables - weekly sales and weekly brand awareness. ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi Anonymous 

    (Alpha - in Alpha slicer, Beta - in Beta slicer)

    since Alpha and Beta and in the same column, why do you want to keep them in two separate slicers?

    Do you have set edit interaction for them to get it?

    If so, I would suggest you put them in one slicer not in two slicers, in your current way, it could not get the last two charts.

     

     

    If you still want to keep them in two separate slicers, you need two separate dim brand table, which is for Alpha and another for Beta.

    then create measure as below:

    Alpha sales = CALCULATE(SUM('weekly sales'[Sales]),FILTER('weekly sales','weekly sales'[Brand] in VALUES(Alpha[Brand])))
    Bate sales = CALCULATE(SUM('weekly sales'[Sales]),FILTER('weekly sales','weekly sales'[Brand] in VALUES(Beta[Brand])))
    sum sales = CALCULATE(SUM('weekly sales'[Sales]),FILTER('weekly sales', 'weekly sales'[Brand] in VALUES(Alpha[Brand])||'weekly sales'[Brand] in VALUES(Beta[Brand])))

     

    Of course, it has the same logic for weekly brand awareness table.

     

    here is sample pbix file, please try it.

     

    Regards,

    Lin

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , which slicer you want to avoid. Not very clear. It seems you already have a common Brand and week dimension. and that is joined to both tables.

Table / Dimension - Brand, Week

Tables /Fact - Table 1, Table 2

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dear amitchandak Thanks for your reply. 

 

I have a report where I have a control panel at the top, then two sales charts, and finally, awareness charts.  On my control board I have two separate slicers (one - for Alpha brands, second - for Beta brands). I select one brand from each group (for example, Alpha 2 in Alpha slicer, Beta 1 in Beta slicer) and easily make separate sales charts, as shown in my example picture). 

 

Yet, I can't make awareness charts, because each slicer filters each group and they don't intersect. Of course, I can make additional slicer with multiple selection after sales charts and manually select there Alpha 2 & Beta 1, but I want to avoid it. 

 

So I was thinking of some solution which can: 1) understand, what is selected in each of Alpha and Beta slicers 2) combine selection of Alpha & Beta slicers 3) use this selection as a pre-filter for awareness charts. 

 

Hope I made the issue clearer.