Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
saykasku
Resolver I
Resolver I

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?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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:

 

Capture.PNG

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Could you maybe explain the problem a bit more in detail? im not sure if i understand correctly. Also, maybe add some sample data?

Example:

Sample data - Column with 10 digits (string, 10 millions unique rows) 

 

a.PNG

 

I need to filter report using this column.
My idea was that:

 

aa.PNG

 

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.
aaa.PNG

 

No ideas here...

Anonymous
Not applicable

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:

 

Capture.PNG

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...

Anonymous
Not applicable

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 ! 🙂

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors