Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Custom Visual "Text Filter" Does Not Filter for Data Overflow

 

Good morning friends. I have difficulty writing a report. I want to set up a search filter for the user to search the order code they want, but I have a lot of data. Even filtering the date eg, just for 2019 the custom visual "Text filter" does not filter for excess data. What to do?

 

Need Help
Show and Tell
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

    The custom visual "Text Filter" is limited to 1300 rows for now. And you could focus on the thread about when increase the limitation of Text Filter. For a workaround, you could change the data type of CODE to text and put into slicer to search.

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    In the image it says: "Excess values". Not showing all data. Filter the data or select another field. "

    • v-xuding-msft's avatar
      v-xuding-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ,

      The custom visual "Text Filter" is limited to 1300 rows for now. And you could focus on the thread about when increase the limitation of Text Filter. For a workaround, you could change the data type of CODE to text and put into slicer to search.

      Best Regards,

      Xue Ding

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.