cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MiraNi Regular Visitor
Regular Visitor

Re: Text Filter is limited to 1000 values exactly

Great, thank you very much for information!

Lolo Frequent Visitor
Frequent Visitor

Re: Text Filter is limited to 1000 values exactly

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

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

MiraNi Regular Visitor
Regular Visitor

Re: Text Filter is limited to 1000 values exactly

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.

Lolo Frequent Visitor
Frequent Visitor

Re: Text Filter is limited to 1000 values exactly


@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

help2.PNGCapture.PNG

MiraNi Regular Visitor
Regular Visitor

Re: Text Filter is limited to 1000 values exactly

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

Lolo Frequent Visitor
Frequent Visitor

Re: Text Filter is limited to 1000 values exactly

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.

MiraNi Regular Visitor
Regular Visitor

Re: Text Filter is limited to 1000 values exactly

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

Highlighted
v-evelk Senior Member
Senior Member

Re: Text Filter is limited to 1000 values exactly

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

S_Sanchez Frequent Visitor
Frequent Visitor

Re: Text Filter is limited to 1000 values exactly

Almost 2 months later, still nothing 😞

v-evelk Senior Member
Senior Member

Re: Text Filter is limited to 1000 values exactly

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

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 62 members 1,022 guests
Please welcome our newest community members: