Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Unable to use Top-N filter functionality on a Slicer

‎07-15-2019 12:39 PM

Hello,

I am trying to restrict the number of records that a slicer would retrive by using Top-N functionality but it doesn't seem to be working. I am trying to display bottom 100 PRO_NBR_TXT (Field Value) on the basis of Invoice_ID but the visual is erroring out. Just wanted to give heads-up, the field PRO_NBR_TXT has more than 10M values. 

 

image.png

 

Thanks, 
Jash

Labels:
Message 1 of 2
255 Views
0
1 REPLY 1
v-cherch-msft
Microsoft Employee
Microsoft Employee

‎07-15-2019 07:42 PM

Hi @Anonymous 

Please check if below article could help.

https://www.sqlbi.com/articles/tuning-query-limits-for-directquery/

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 2
240 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

View All