Build a comparison report by selecting one data point

[datadelta]

This one seems to be stumping me.

I have a BI report capturing 10 different data points from 22 different customers.  The reports show a breakout of each area of measurement for service by customer.

What I'm trying to figure out how to do is, create a slicer that will allow the customer to choose their associated identifing ID and pull in a report that shows how they rank overall for all service measurements.

So, if my ID is 10, I want to have a slicer that I can choose my ID number and a summary report will pull from all the collected data and say; Turnaround Time, Rank 2 - Quality, Rank 5 - etc..

Not sure how to provide details to get help on this one.

Thanks.

[lbendlin · Accepted solution]

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-...
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