Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Custom Visual Text Filter -- data limitation

HI, I have a very large dataset, imported to my local workspace. When I use the Text Filter to search for data, it doesn't always find it. Is there any limitation of data size that the filter can su...
dm-p's avatar
dm-p
Super User
2 years ago

Hi Anonymous,

 

For looking at the source code, it looks like they are using the maximum limit of 30,000 rows. This means that if you have more than 30,000 unique values of the column you're attempting to filter, then some of them will be omitted based on the order they are sent to the visual by Power BI.

 

Regards,

 

Daniel

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks! If that's how it is, is there a way to prompt the end user enter the value for filtering?

 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Have a training session with them where you teach them how to use the filter pane.