Need Help: How to filter graphs with X data points

[Aidenn90]

I have a large data set that I have graphed and I would like to find a way to use a slicer to show only the last 100 data points. Example below:

Category	Time/Date	Value
A	1/1/24 6:00	5
A	1/2/24 8:00	89
B	1/10/24 1:00	7
B	1/10/24 5:00	274
C	1/20/24 9:00	34
A	2/10/24 11:00	58
A	2/18/24 1:00	69
F	4/10/24 0:00	91

I already have a slicer that allows me to filter the graph by catagory, i would like to make a second slicer that allows me to show the last 100 data points. I currently have a relative data slicer that show the last 30days, sometimes thats 10 data points and other time thats 1000 data points. 

Is there a way to tell it go as far back or as required to always show 100 (or x so i can adjust as i want) data points, even if its 2 days or 2 years?

Thanks,

[Anonymous]

Hi @Aidenn90 ,

Is your requirement that you want to show the last data points based on date/time?

I suggest you to try TopN function in visual level filter.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rsbin]

@Aidenn90 ,

You can create a Calulated Column to Rank your [Time/Date] column:

RANK = RANK(DENSE, ORDERBY('Table'[Time/Date], ASC))

Then use your filter panel to filter the number of records you want to see or create a Slicer so the User can select the number of records they want to view.

Hope this is what you were looking for.

Regards,