Display 7 days of data

[ask]

Hi,

I need to create a chart which need to dislay day 0 (matched day), day 1, day 2, day3.....until next matched date. Anyone knows how to do that?

[Anonymous]

Sounds like you would like a date slicer, which allows the user to select the From and To dates.  This provides a filter context for your graph and will only display between those two dates.

Depending on the number of tables you are working with, you might want a Date Dimension table to link all of your data through.  You can build one like this:
http://www.agilebi.com.au/power-bi-date-dimension/

[ask]

@Anonymous the report doesn't allow the slicer. It is  to set a default 7 days of line chart from the matched date, until next matched date.

[v-yuezhe-msft]

@ask,

Please help to share sample data of your table and post expected result here. You may need to create measure to calculate the 7 days data.

Regards,
Lydia