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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
powerbiguy_
Frequent Visitor

Parameterized list that may contain thousands of records

Good day!

 

Need suggestions!

 

I am transitioning from appeon powerbuilder reports to power bi. I already created some of my reports to power bi, I have this one particular report that has two paramaters (1) accountnumber (2) billmonth - month and year, month = first two digits and last four digits = year.

 

1. If the user knows the exact account number then he/she will enter it to the parameter field and select a billmonth from the dropdown list  then the consumption graph for that year will be shown

2. If the user did not know the exact account number then he/she will just enter a part of the fullname of the consumer. A list will be displayed and the user will select a consumer on the list and select a billmonth from the dropdown list  then the consumption graph for that year will be shown

 

These are the sample tables:

 

Consumers
IdAccountNumberLastNameFirstName
1123787DominguezBeth
2456234ClaireJamie
3545436DuffCharles
4535443St. JohnLawrence

 

Consumptions
IdConsumerIdBillMonthConsumption
1101202020
2102202070
3103202045
4104202032
5105202063
6201202011
720220208
8203202021
9204202018
1020520206
11301202011
12302202018
13303202015
14304202010
1530520209
16401202022
17402202031
18403202030
19404202033
20405202026

 

Here is the actual form and the report:

 

powerbiguy__0-1618024841101.png

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Is your concern the speed of the search in the field?  I created a sample with 1M customers and made a combined column of Customer Number - Last Name, First Name and put it in a slicer.  If you put it in a drop view and enable search you can see how it reacts when you search on the list and it's fine and if they know the account number they can just put that in the search.  My sample .pbix is attached at the bottom of the post.

jdbuchanan71_0-1618028941817.png

jdbuchanan71_1-1618029045589.png

 

 

View solution in original post

1 REPLY 1
jdbuchanan71
Super User
Super User

Is your concern the speed of the search in the field?  I created a sample with 1M customers and made a combined column of Customer Number - Last Name, First Name and put it in a slicer.  If you put it in a drop view and enable search you can see how it reacts when you search on the list and it's fine and if they know the account number they can just put that in the search.  My sample .pbix is attached at the bottom of the post.

jdbuchanan71_0-1618028941817.png

jdbuchanan71_1-1618029045589.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.