Forum Discussion

murpoj's avatar
murpoj
Frequent Visitor
9 years ago
Solved

Top N Filter in Power BI Service

I have a problem with Top N Ffilter in Power BI Service. I have a table with a datetime column, and I'm tying to get only the last 10 rows. I choose Top N as filter, enter the value 10, and select latest from "By Value" dropdown. Then nothing is shown. When I do the same thing in Power BI Desktop, it works.

 

Is there an issue with Top N filter in Power BI Service?

Need Help
  • murpoj's avatar
    murpoj
    9 years ago

    Yes there are dates. I found a workaround,, by converting the dates into strings. I noticed that other types of values like numbers and strings work with Top N filter. It's not ideal but it's sufficient for now.

     

    Thanks.

8 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi murpoj,

     

    According to my test, Top N filter works fine. There isn't a dropdown of "By Value" in my test. Could you please post some snapshot of this issue?

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

    • murpoj's avatar
      murpoj
      Frequent Visitor
      9 years ago

      This is the unfiltered version:

       

      And this isthe filtered version:

       

      I guess "by value" part only becomes dropdown with datetime columns. The same filter works on Power BI Desktop, but not on Service.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        9 years ago

        Hi murpoj,

         

        I reproduce it in this scenario. If the top 50 timestamp don't have a value, the visual would be blank. So try 500, 5000 or bigger instead of 50. If the visual shows data, this would be the cause. Please try it first. 

         

        Best Regards!

        Dale