topic Different slicers for different columns in one product matrix in DAX Commands and Tips

Different slicers for different columns in one product matrix

derekjdmurphy88 — Wed, 22 Jan 2025 15:36:00 GMT

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

Re: Different slicers for different columns in one product matrix

Anonymous — Thu, 23 Jan 2025 06:49:05 GMT

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.

Re: Different slicers for different columns in one product matrix

derekjdmurphy88 — Fri, 24 Jan 2025 00:23:23 GMT

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