Forum Discussion

ajitsahoo8338's avatar
ajitsahoo8338
Icon for Helper III rankHelper III
1 year ago
Solved

How to filter Next "X" weeks data dynamically

I have created this table chart, where I am showing the project number and their releases with respect to the week number. I want to create a slicer where I can enter any number, and based on that nu...
  • Vijay_Chethan's avatar
    1 year ago

    Instead of table , matrix visual could be better for you use case 
    where u can add project names in rows section while in date table you can create new column:

    Week = WEEKNUM([Date],1)

    use this Week in column section

    Now create a Numeric field parameter(in Modelling tab) and name it say week_count

    then create a measure:
    (im assuming your each release is a different record in table, if not change accordingly)

    project_count = 
    var curr_week=WEEKNUM(Today(),1)
    return
    calculate(countrows(table[column]),filter(Date table,[Week]>curr_week && [Week]<curr_week+3))

    now use this measure in the values section



    if this helps you in any way, please accept it as solution