Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 | |||
Id | AccountNumber | LastName | FirstName |
1 | 123787 | Dominguez | Beth |
2 | 456234 | Claire | Jamie |
3 | 545436 | Duff | Charles |
4 | 535443 | St. John | Lawrence |
Consumptions | |||
Id | ConsumerId | BillMonth | Consumption |
1 | 1 | 012020 | 20 |
2 | 1 | 022020 | 70 |
3 | 1 | 032020 | 45 |
4 | 1 | 042020 | 32 |
5 | 1 | 052020 | 63 |
6 | 2 | 012020 | 11 |
7 | 2 | 022020 | 8 |
8 | 2 | 032020 | 21 |
9 | 2 | 042020 | 18 |
10 | 2 | 052020 | 6 |
11 | 3 | 012020 | 11 |
12 | 3 | 022020 | 18 |
13 | 3 | 032020 | 15 |
14 | 3 | 042020 | 10 |
15 | 3 | 052020 | 9 |
16 | 4 | 012020 | 22 |
17 | 4 | 022020 | 31 |
18 | 4 | 032020 | 30 |
19 | 4 | 042020 | 33 |
20 | 4 | 052020 | 26 |
Here is the actual form and the report:
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |