Forum Discussion

javieezy's avatar
javieezy
Icon for Helper I rankHelper I
5 years ago

Problem with visual filter "TOP N"

Dear all, 

 

Here I got a visual that I want to show only for the last 4 weeks. What can I do to get it automated filtered? 

 

I tried to filter "TOP N" by Week Number but seems sth is wrong: 

 

Currently, I'm updating it by "Greater than", changing the number manually every week, it's correct: 

 

So I supposed these two filters have the same effect but obviously I was wrong, I want to know why? 

 

Also, any other way to have the latest 4 weeks without updating manually the filter? 

 

 

Thank you!

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    javieezy , The first one should work

     

    Create a measure max(Table[week number]) and use that in the filter and try.

     

    Can you share a sample pbix after removing sensitive data.