Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create 2 date slicers with same Date column

Hi!!   I would like to create 2 date slicers that are using the same Date column. This is how i want it to work:    First slicer: is showing the last 7 days, always visible. Second slicer: is l...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You can create a separate table.

     

    Then create the measure.

    Filter results = 
SWITCH (
    SELECTEDVALUE ( 'Table (2)'[Slicer] ),
    "last 7 days",
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER ( 'Table', [Date] >= TODAY () - 6 && [Date] <= TODAY () )
        ),
    "last 30 days",
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER ( 'Table', [Date] >= TODAY () - 29 && [Date] <= TODAY () )
        )
)

     

    You can check more details from here.

     

    Best Regards,

    Stephen Tao

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.


Best Regards,
Stephen Tao