Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
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.
User | Count |
---|---|
84 | |
77 | |
76 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
45 | |
43 |