Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I work with technicians and I need to analyse their skills.
I'd like to show for exemple people having bad customer satisfaction with a Chart and display a table with a short list of people having the best .
What I'm trying to do is :
if filtered Customer_Satisfaction < Customer_Satisfaction of X ( using the same filter , since i'd like to match people from the same team or at least from the same area )
then display X
else Hide X
Here is a small preview of filters , chart and table I need :
I know I could do a Top N , but I 'd like to show only people better than the selected one .
I tried few Dax formula but I don't reach my goal since I not able to compare value from the chart and value in the Table...
Does anybody has a lead ?
TIA 🙂
Solved! Go to Solution.
You can't do that if the data tables are related. You need to create a disconnected shadow table with just the technicians' names and then use that table to feed your filter slicer. Then use SELECTEDVALUE() in your measure to calculate if a particular data point from your data tables should be shown (equal or better than selection) or not (worse than selection)
You can't do that if the data tables are related. You need to create a disconnected shadow table with just the technicians' names and then use that table to feed your filter slicer. Then use SELECTEDVALUE() in your measure to calculate if a particular data point from your data tables should be shown (equal or better than selection) or not (worse than selection)
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |