Forum Discussion
Large dim table and filter
The only thing you need is the search bar? in that case you can use this:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380794?tab=Overviewi used it myself, and it looks like this:
Example:
Sample data - Column with 10 digits (string, 10 millions unique rows)
I need to filter report using this column.
My idea was that:
I can filter using 10 slicers (fast because of only 10 unique calues in one column) but user want one text box because of copy-paste possibility.
No ideas here...
The only thing you need is the search bar? in that case you can use this:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380794?tab=Overview
i used it myself, and it looks like this:
This search bar is using only on column with full customer id but its 5 minutes for filter because of 10 millions unique values...
It's very bad. I need better solution...
Have you used the search bar i suggested? because i do not have this loading problem with 14m rows.
You have right. It's working. Thx mate ! :)