Forum Discussion
Plotting focused data against broad data
Hi All,
Hoping someone can assist with my enquiry.
I have a table of data that contains data specific to registrations that my team has completed.
I'm trying to be able to select a member of the team and plot their registrations count per month against the entire teams average registration count per month on a table.
I'm struggling with this because when I select a specific team member on my page's slider, all the graphs/cards information is filtered to that specific individual.
Is there any way I can calculate registration counts of an individual and for an entire group and plot them on the same graph?
Thanks and regards.
1 Reply
- lbendlinSuper User
Create measures that remove the filter context (in your case the member constraint).
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523