how can i filter table and line chart to show 30 days of data

[Shubham_Yadav]

Hi, i want to show 30 days data in table and chart, 

I want to show top 5 highest data in table from 30 days and show them in below chart but having x axis showing those 30 days dates.

I have start and end measures which is being used to filter the report

Any help will be appreciated

[v-jayw-msft · Accepted solution]

Hi @Shubham_Yadav ,

You could create a measure like below:

Mesure = 
var end_date_measure = [start_date_measure] + 30
return
IF(SELECTEDVALUE('Table'[date]>=[start_date_measure]&&SELECTEDVALUE('Table'[date])<end_date_measure,1,0)

Add this measure to the visual filter and set value = 1.

Best Regards,

Jay

[croberts21]

Do you always want to show the chart for the past 30 days only basedon today's date? For this, use the TODAY() function in a formula sort of like this: TODAY()-30. 

Or do you want to have the user enter the date which is 30 days prior to today?

[Shubham_Yadav]

Hi @croberts21 , i want to show 30 days of data as per user selection on start date, as it is flexible i.e user can select any value from start .So it will be a range of data from start to end and not TODAY() data