Different slicers for different columns in one product matrix

[derekjdmurphy88]

Hi , I'm looking for help regarding slicers to a matrix. I have 5 slicers which I want to show different periods in each column but I'm running into issues. 1. It will only show in the figures if I select the first slicer selection in all 5 slicers. 2. When I try and select a different period from the first slicer the matrix just goes blank.

I've created 5 tables- one for each column and created relationships with each table to the data table. 

Next I've set up a measure for the

 

different slicers.

Next I have set up another measure for the column 

 But it doesn't seem to work. As previously mentioned it will only show the same information if all slicers are selected are the same 

 Any help on this would be very much appreciated  please and thank you 

[derekjdmurphy88 · Accepted solution]

Thanks a million for taking the tim to help me with this query tom really appreciate  it.  This has been most helpful.  Thanks again 

[Anonymous]

Hi @derekjdmurphy88 ,
Based on this problem of yours, it may be caused by the fact that the slicers of multiple dates are not uniformly scheduled, and power bi is not able to recognize the correct interval for each slicer, but of course there is a solution for this, and the following is the solution that I have provided for you:

Sales for Slicer 1 = 
CALCULATE(
    [Total Sales],
    FILTER(
        'Sales Table',
        'Sales Table'[Date] IN ALLSELECTED('Table 1'[Date])
    )
)

Sales for Slicer 2 = 
CALCULATE(
    [Total Sales],
    FILTER(
        'Sales Table',
        'Sales Table'[Date] IN ALLSELECTED('Table 2'[Date])
    )
)

We let each of our filters only for their own table for the date of the filter, so as not to affect the other table filters, so as to achieve the effect you need, I hope this will be helpful to you!
If you have any further questions you can check out my pbix file, I would be honored if I could solve your problem!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.