Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
36 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
37 | |
29 | |
29 | |
24 |