Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Hi, 1.2.1 is now on AppSource. I've just notice it.
@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
Thank you for details but where and how can I find the file and open it to be able to edit it?
Hi @MiraNi ,
when you create a visual using the powerbi-visuals-tools you should have a folder containing all the visual files Here is an example of how to create a visual. Just open the folder in Visual studio code or visual studio and there you should see the file capability Json and just click on it to open.
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
What about now ? Any update on this ?
I was wondering if we can avoid that issue by doing something different in the design of the filter or the way the final user interact with the report. Thanks in advance.
Hi,
I asked developers regarding the issue.
As soon as they answer I will provide info here.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com
The developers answered that they will increase the limit in the next release, however they didn't provide any ETA.
Usually, they deliver fixes and features quickly enough for they visuals, however we need to take in account also time for delivering to production server. So, I suppose it will take not less than a month.
You also have an option to fork the repo of the visual and add a key "dataReductionAlgorithm" in capabilities.json, change GUID and build a package to use it instead of visual form the store. More detailed info about the key you can find here.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com
Is there an idea about the row amount increase created in community, what I could follow to know, when it's ready for production?
Hello,
I don't see that the visual team sent any changes for publication. The didn't provide any ETA but I will ask them about the status again and will share info here.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com
The visual team is going to publish changes at the end of this week, then it requires 2-3 weeks to deliever release on prod.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com
Hi,
I have tested the filtering and I still get the error message for too many values with 1300 rows. So I assume, the update is still not in production? I have got all these good instructions for customizing my own visual but it is not an option now.
Rgds, Mira
Hi Mira,
I've requested details regarding this issue from developers again.
As soon as I receive response from them, I will answer here.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com
I would beg for help!
How can I search for multiple criteria using a text filter?
If I write:
auto * limousine
throw out all the lines that contain "car" and "limousine", but only if they are in that order.
If the item contains the word "limousine" first, then "auto", that line is not displayed.
How to solve it?
Thanks a lot in advance!
Greetings
Almost 2 months later, still nothing 😞
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.