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 la...
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.

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft 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

      • murpoj's avatar
        murpoj
        Frequent Visitor
        9 years ago

        I tried larger values, but still didn't work. I published a desktop report with similar data to Power BI service, and Top N Filter with timestamp worked for that report. The problem report uses streaming dataset, maybe it has something to do with it.