Forum Discussion

Aidenn90's avatar
Aidenn90
Frequent Visitor
1 year ago

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:

CategoryTime/DateValue
A1/1/24 6:00

5

A1/2/24 8:00

    89

B1/10/24 1:00

 7

B1/10/24 5:00

274

C1/20/24 9:00

34

A2/10/24 11:00

58

A2/18/24 1:00

69

F4/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,

Need Help

2 Replies

  • rsbin's avatar
    rsbin
    Community Champion
    1 year ago

    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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.