topic Re: Control Data : Multi Slicer in DAX Commands and Tips

Control Data : Multi Slicer

Chandrashekar — Wed, 21 Dec 2022 06:17:02 GMT

Hello,

How to control data with muti slicer[Date & Week No)

PBIX File: Sample Data

Regards,

Chandrashekar B

Re: Control Data : Multi Slicer

DimaMD — Wed, 21 Dec 2022 07:19:29 GMT

Hi Chandrashekar Can you provide your expected result?
If you want to see the result by week, then add the week number in the column of the matrix table.

Re: Control Data : Multi Slicer

Chandrashekar — Wed, 21 Dec 2022 08:30:24 GMT

Hello,

is it possible slicer act individually. For ex:

1. If I select week then it should week wise data in both the table

2. If I select date range it should date wise data in both the table.

Regards,

Chandrashekar B

Re: Control Data : Multi Slicer

DimaMD — Wed, 21 Dec 2022 08:41:30 GMT

Chandrashekar Please review the attached file and tell me if this is your desired result

Re: Control Data : Multi Slicer

Chandrashekar — Wed, 21 Dec 2022 09:06:17 GMT

Hello,

If I select particular week(Week Num Slicer) date range slicer is not working. If I select date range slicer I should get data from 01-11-2022 to 22-12-2022(as per selection).

is it possible that Slicer work independently?

Re: Control Data : Multi Slicer

DimaMD — Wed, 21 Dec 2022 09:24:08 GMT

Chandrashekar Yes, you need to unfilter both tables.
Click on the WeekNum slicer, go to the Format tab, and click Change Interactions
Do the same for the Date Slicer

Re: Control Data : Multi Slicer

Chandrashekar — Wed, 21 Dec 2022 09:33:31 GMT

Hello,

Thanks.

Regards,

Chandrashekar B