Forum Discussion

Johnrevheim's avatar
Johnrevheim
Frequent Visitor
9 years ago

Separate sliders for different ledgers

Hello,

is it possible to have separate slider for different ledgers in the same graph? I have a dataset with purchases where the booking date is ddmmyyyy. I want to compare incoming reservations for 2017 vs same time in 2016 in the same graph. Any suggestions?

 

Thank you

John

3 Replies

  • PavelR's avatar
    PavelR
    Icon for Solution Specialist rankSolution Specialist

    Johnrevheim

     

    why you need two separate filters (sliders)? Just use SAMEPERIODLASTYEAR DAX function.

     

    Regards.

    Pavel

    • Johnrevheim's avatar
      Johnrevheim
      Frequent Visitor

      Hi,

      thank you but I do not have a contiguous date selection and it does not work without it apparently.

      john 

      • PavelR's avatar
        PavelR
        Icon for Solution Specialist rankSolution Specialist

        Then create date table with CALENDAR function - this will create contiguous dates.