Forum Discussion
BillyT_350
Helper V
Helper Vget Pie Chart to Filter Table
Hello, I've got a pie chart that , from two counting Measures, displays the number of client sites that have or have not been called in a time period. Next to it, I have a table that displays stats a...
MFelix
Super User
Super UserYou can add them to the post as text a e-mail to a onedrive/we tranfers file or send me a Private message with the information.
Regards,
MFelix
BillyT_350Helper V
Helper V*edited OP again*
MFelix I just made up some sample data, and a new PBI Report to go with it so that I can post scrnshts directly from there.
Ok, so technically there is a third table involved here, listing employees and their attributes. I didn't think it was necesary, but I might as well include it.
As you can see, site "ownership" is determined by INITs, but the owner may not necesarily be the person who calls their site. You can see in the screenshot how they are related.
Sites table
| SiteID | SiteName | inits | O Mkt | D Mkt |
| Site1 | Happy Apple Makers | 1 | a | c |
| Site2 | The Most Interesting Man in the World | 2 | b | a |
| Site3 | Sheep Sheerers | 3 | d | b |
| Site4 | Grub's Grub Restaurant | 4 | b | c |
| Site5 | Golum's Precious Finders | 5 | c | d |
Calls table
| CallID | Caller | SiteID | Date |
| c1 | bob | Site1 | 4/1/2018 |
| c2 | joe | Site3 | 4/1/2018 |
| c3 | sally | Site2 | 4/1/2018 |
| c4 | ahmed | Site2 | 4/2/2018 |
| c5 | schmidt | Site2 | 4/1/2018 |
| c6 | nereese | Site1 | 4/1/2018 |
| c7 | juanita | Site3 | 4/2/2018 |
| c8 | oscar | Site2 | 4/2/2018 |
| c9 | ivan | Site1 | 4/1/2018 |
| c10 | joe | Site1 | 4/1/2018 |
| c11 | ahmed | Site1 | 4/2/2018 |
| c12 | joe | Site2 | 4/4/2018 |
| c13 | juanita | Site1 | 4/1/2018 |
| c14 | ahmed | Site3 | 4/2/2018 |
| c15 | oscar | Site2 | 4/1/2018 |
| c16 | sally | Site1 | 4/2/2018 |
| c17 | schmidt | Site2 | 4/1/2018 |
| c18 | juanita | Site1 | 4/2/2018 |
| c19 | oscar | Site2 | 4/2/2018 |
| c20 | juanita | Site1 | 4/1/2018 |
Employees
| Employee | inits |
| juanita | 1 |
| joe | 2 |
| ahmed | 3 |
| schmidt | 4 |
| oscar | 5 |
| bob | 6 |
| sally | 7 |
| nereese | 8 |
| ivan | 9 |