Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
3 years ago
Solved

Control Data : Multi Slicer

Hello,   How to control data with muti slicer[Date & Week No)   PBIX File: Sample Data    Regards, Chandrashekar B
  • Chandrashekar's avatar
    Chandrashekar
    3 years ago

    Hello,

    Thanks.

     

    Regards,

    Chandrashekar B

DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
3 years ago

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.

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
3 years ago

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

  • DimaMD's avatar
    DimaMD
    Icon for Solution Sage rankSolution Sage
    3 years ago

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

    • Chandrashekar's avatar
      Chandrashekar
      Icon for Resolver III rankResolver III
      3 years ago

      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? 

       

       

       

      • DimaMD's avatar
        DimaMD
        Icon for Solution Sage rankSolution Sage
        3 years ago

        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