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,

 

That's weird. I tested it successfully. Please check the dataset by creating a table visual. I noticed the axis is time. Are there any dates?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

murpoj's avatar
murpoj
Frequent Visitor
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.