Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Johnrevheim
Frequent Visitor

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 3
PavelR
Solution Specialist
Solution Specialist

@Johnrevheim

 

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

 

Regards.

Pavel

Hi,

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

john 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.