CODEWITHSUNDEEP
powerbidaxpowerbi-desktop
Serdia
Serdia

Reputation: 4418

How to create slicer As Of (Up To) Date in Power BI desktop

In my dim_Date table I have column MonthYear. But how can I write the expression so when choosing a value, the data would be filtered UP TO that date, so everything from the beginning and up to that date?

For example if I select Nov-2018, the data should be displayed from the beginning and up to Nov-2018?

Thanks

enter image description here

UPDATE:

Cant see options "Before" or "After"

enter image description here

This is my dim_Date table:

dim_Date = ADDCOLUMNS(
    CALENDAR (DATE (2017, 1, 1), DATE (YEAR(TODAY())+1, 12, 31)),
    "DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
    "Year", YEAR ( [Date] ),
    "MonthNumber", FORMAT ( [Date], "MM" ),
    "MonthYear", FORMAT ( [Date], "mmm-YYYY" )
)

Upvotes: 0

Views: 270

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

It's definitely possible to do with a list slicer, but the easiest option is to just use a different form of the slicer.

enter image description here

Upvotes: 1

Related Questions