Forum Discussion
Need Help: How to filter graphs with X data points
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 ...
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,