Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
There are 6 visuals on the page which display line chart for "no of orders" over time( month by month) a team receives. for example Team consists of 10 salesmen.
To compare, the requirement is to let user select upto 6 salesmen. Based on the selection of user, for exampe if user chooses 4 sales men, we wanted to show 4 visuals.
There are other ways to compare too but just wanted to stick with this idea to keep 6 visuas per page and show only no of visuals based on no of salesmen seleted.
Thanks in advance
If I create this scenario with example it will be like
Salesman
SalesmanID | Saleman Name |
1 | David |
2 | Michael |
3 | John |
4 | Liza |
5 | Andy |
6 | Josh |
7 | Felix |
8 | Toby |
9 | Adam |
10 | Richard |
Sales
SalesmanID | OrderDate | OrderID |
1 | 10/12/2020 | 1 |
1 | 4/4/2020 | 2 |
1 | 1/5/2020 | 3 |
2 | 7/7/2020 | 4 |
3 | 10/12/2020 | 5 |
4 | 4/8/2020 | 6 |
5 | 1/1/2020 | 7 |
4 | 10/12/2020 | 8 |
3 | 4/4/2020 | 9 |
6 | 7/8/2020 | 10 |
7 | 1/1/2020 | 11 |
8 | 10/12/2020 | 12 |
9 | 4/4/2020 | 13 |
8 | 7/9/2020 | 14 |
7 | 4/4/2020 | 15 |
4 | 10/12/2020 | 16 |
4 | 1/1/2020 | 17 |
3 | 4/6/2020 | 18 |
1 | 7/7/2020 | 19 |
2 | 10/12/2020 | 20 |
5 | 4/4/2020 | 21 |
6 | 1/1/2020 | 22 |
7 | 10/12/2020 | 23 |
10 | 7/10/2020 | 24 |
10 | 1/1/2020 | 25 |
10 | 10/12/2020 | 26 |
10 | 1/10/2020 | 27 |
3 | 3/3/2020 | 28 |
6 | 5/5/2020 | 29 |
9 | 5/5/2020 | 30 |
1 | 10/12/2020 | 31 |
2 | 4/4/2020 | 32 |
3 | 1/10/2020 | 33 |
4 | 7/7/2020 | 34 |
5 | 10/12/2020 | 35 |
6 | 10/12/2020 | 36 |
7 | 4/4/2020 | 37 |
8 | 1/11/2020 | 38 |
9 | 7/11/2020 | 39 |
10 | 10/12/2020 | 40 |
1 | 10/12/2020 | 41 |
2 | 4/4/2020 | 42 |
3 | 1/11/2020 | 43 |
4 | 7/7/2020 | 44 |
5 | 10/12/2020 | 45 |
6 | 11/12/2020 | 46 |
7 | 4/4/2020 | 47 |
8 | 1/1/2020 | 48 |
9 | 7/7/2020 | 49 |
10 | 10/12/2020 | 50 |
1 | 10/12/2020 | 51 |
2 | 4/4/2020 | 52 |
3 | 1/1/2020 | 53 |
4 | 7/7/2020 | 54 |
5 | 10/12/2020 | 55 |
6 | 10/12/2020 | 56 |
7 | 4/4/2020 | 57 |
8 | 1/1/2020 | 58 |
9 | 6/11/2020 | 59 |
10 | 12/12/2020 | 60 |
@Anonymous
Instead of bookmarks, you could try to use the newest feature in some of the native visuals called "small multiples." Also, there are visuals in the store from third-party vendors that have small multiples enabled.
Hi @Anonymous ,
You need to play with bookmarks.
Here is an example: https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Thanks @ERD It very useful.
Do you know when user selects 6 Salesmen using below measure,
Result brings as
David, Felix, Liza, Michael, Richard, Toby
What will be the DAX to store [SelectedFilterSalesman] into 6 measures having each salesman name?
Regards
User | Count |
---|---|
54 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |