Forum Discussion
Text Filter is limited to 1000 values exactly
The Text Filter visual only allows exactly 1000 values right now, otherwise it will throw an information box stating ‘Too many values’. Can this limit be increased to 5000, removed, or made configurable by the user?
Typically, I will impose my own limits via a measure that returns the count of values, and add it to the visual filters section.
Solutions (Most ideal to least ideal):
1. Remove the limit, and allow user to specify with a measure as a visual filter.
2. Make the limit configurable via the Visual Format pane.
3. Increase the limit to 3000 or 5000.
27 Replies
MiraNi use this
"dataReductionAlgorithm": {
"top": {
"count": 2000
}
}the max limite is 30 000 datapoint see this link Data Reduction Algorithm section at the end
Thanks for tip but how can I start using that algorithm? Where can I make changes for capabilities.json? I am not familiar with that yet.
MiraNi wrote:Thanks for tip but how can I start using that algorithm? Where can I make changes for capabilities.json? I am not familiar with that yet.
The Data Reduction Algorithm goes into the datatviewmappings. in addition, you must refer to the fields on which the data reduction algorithm will apply. look at the picture below. Where I drew the blue line, is the name of the field on which the datareduction is going to be applied. if you still do not understant i invite you to look again at the examples here
Text Filter is limited to 1000 data rows due to default Power BI limitation for custom visuals.
We'll discuss the possibility to increase the data limitation with engineering team.Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Any update on this?
Development team is considering this feature.
We'll update this topic once it's implemented.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
