Display year,quarter,month and day Charts based on the selected Date

[Anonymous]

Hi All,

There are four line charts for Year,Quarter,Month,Day in my power bi report.

The requirement is to pick a date from the date picker and based on the selected date I need to display graphs accordingly(selected date and 3 values back).

E.g. If user select 1.1.2018 from date picker, I need to display graphs with year,quarter,month,day belong to 1.1.2018 and 3 more values(years,quarters,months,days) back.

I have added visual level filters for each line chart and got filtered top 4 values.but it works for year chart only. any ideas?

Data set

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may add a separate table for Slicer, use DATEDIFF to apply virtual relationship in DAX measure and then take advantage of Visual level filters.

https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single-date/m-p/588265#M278953