Forum Discussion

jsh121988's avatar
jsh121988
Icon for Microsoft Employee rankMicrosoft 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 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

  • 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
      Icon for Advocate IV rankAdvocate 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

  • v-viig's avatar
    v-viig
    Icon for Community Champion rankCommunity Champion
    8 years ago

    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

    [email protected]

      • v-viig's avatar
        v-viig
        Icon for Community Champion rankCommunity Champion
        8 years ago

        Development team is considering this feature.

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

         

        Ignat Vilesov,

        Software Engineer

         

        Microsoft Power BI Custom Visuals

        [email protected]

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Hi All Do we have alternative as still i can see, its filters only 1000 rows. 
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi, 1.2.1 is now on AppSource. I've just notice it.