topic Re: Text Filter is limited to 1000 values exactly in Custom Visuals Development Discussion

Text Filter is limited to 1000 values exactly

jsh121988 — Mon, 26 Mar 2018 17:24:20 GMT

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.

Re: Text Filter is limited to 1000 values exactly

v-viig — Tue, 27 Mar 2018 14:08:21 GMT

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

pbicvsupport@microsoft.com

Re: Text Filter is limited to 1000 values exactly

Kamarto — Tue, 08 May 2018 07:25:45 GMT

Any update on this?

Re: Text Filter is limited to 1000 values exactly

v-viig — Tue, 08 May 2018 10:09:52 GMT

Development team is considering this feature.

We'll update this topic once it's implemented.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Text Filter is limited to 1000 values exactly

JesusLO912 — Wed, 08 May 2019 18:35:45 GMT

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.

Re: Text Filter is limited to 1000 values exactly

v-evelk — Wed, 15 May 2019 13:24:35 GMT

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

Re: Text Filter is limited to 1000 values exactly

v-evelk — Thu, 16 May 2019 14:39:19 GMT

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

Re: Text Filter is limited to 1000 values exactly

MiraNi — Mon, 24 Jun 2019 09:05:37 GMT

Is there an idea about the row amount increase created in community, what I could follow to know, when it's ready for production?

Re: Text Filter is limited to 1000 values exactly

v-evelk — Tue, 25 Jun 2019 15:13:48 GMT

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

Re: Text Filter is limited to 1000 values exactly

v-evelk — Wed, 26 Jun 2019 07:01:16 GMT

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

Re: Text Filter is limited to 1000 values exactly

MiraNi — Wed, 26 Jun 2019 07:02:52 GMT

Great, thank you very much for information!

Re: Text Filter is limited to 1000 values exactly

Anonymous — Wed, 03 Jul 2019 16:57:28 GMT

@MiraNi use this
"dataReductionAlgorithm": {
"top": {
"count": 2000
}
}

the max limite is 30 000 datapoint see this link Data Reduction Algorithm section at the end

Re: Text Filter is limited to 1000 values exactly

MiraNi — Mon, 22 Jul 2019 09:53:38 GMT

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.

Re: Text Filter is limited to 1000 values exactly

Anonymous — Mon, 22 Jul 2019 13:07:52 GMT

@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

Re: Text Filter is limited to 1000 values exactly

MiraNi — Mon, 29 Jul 2019 06:48:42 GMT

Thank you for details but where and how can I find the file and open it to be able to edit it?

Re: Text Filter is limited to 1000 values exactly

Anonymous — Mon, 29 Jul 2019 13:21:14 GMT

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.

Re: Text Filter is limited to 1000 values exactly

MiraNi — Mon, 09 Sep 2019 12:36:49 GMT

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

Re: Text Filter is limited to 1000 values exactly

v-evelk — Mon, 16 Sep 2019 14:53:44 GMT

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

Re: Text Filter is limited to 1000 values exactly

S_Sanchez — Fri, 08 Nov 2019 21:03:45 GMT

Almost 2 months later, still nothing 😞

Re: Text Filter is limited to 1000 values exactly

v-evelk — Mon, 11 Nov 2019 13:12:22 GMT

Hi guys,

Sorry for this and thank you for your patience.

I've requested clarification from a visual team once again.

I will continue ask them every day this time until they clarify the status.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com