Skip to main content

Power BI

New

Relative Date Slicer Improvement: This & Last

Vote (13) Share
Nick's profile image

Nick on 06 Nov 2017 23:55:36

An improvement I'd like to see on the relative date slicer is the ability to select an option for "This and Last" xx "Years/Months/Days/etc". So if I want to compare at a glance a chart with this year's numbers with the last 2 it would be a lot easier.

Comments (1)
Nick's profile image Profile Picture

3101328d e4e2-4d82-a3ff-9aefdd878e1e on 05 Jul 2020 23:05:33

RE: Relative Date Slicer Improvement: This & Last

I think what I want is functionally equivalent. I want to show "the last 13 calendar months, including this month."

Or, "the last 3 calendar years, including this year." So that I can show two full years of history, plus the current year (year-to-date).

Notice that if your slicer is for "last X days," then you get a checkbox for "Include today."

I think the natural extension would be: if you slicer is for "last X calendar months," then there should be a check box for "Include this month"...or if your slicer is for "last X years," then there should be a check box for "Include this year."