Forum Discussion
Large dim table and filter
I have to create simple report in PBI - only one dim and fact. No aggregations, hierarchies or other stuff. Customer dimmension have 10 millions unique elements and i have problem with filter. I need to filter this dim using string column (10 digits in string because of starting 0). I don't know how to do that quickly...
My idea is to split that column to 10 other columns with only one digit in each. I have problem here too because user want to copy-paste that full number but he have 10 filters. Performance using this 10 columns is ok.
Can you help me with this somehow?
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:
6 Replies
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=Overviewi used it myself, and it looks like this:
