Forum Discussion

jsh121988's avatar
jsh121988
Microsoft Employee
8 years ago

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 configur...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
MiraNi
Advocate IV
7 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    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

    • MiraNi's avatar
      MiraNi
      Advocate IV
      7 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.