Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm creating a supplier scorecard and needed to compare supplier rating values to the population rating values based on buckets (Cost, Performance, Knowledge, Recommendation). The process is twofold, needing to find 1) which values in the sample are greater than the values in the population group and return that group of values, 2) which is the max of those values in the sample group that is greater than the population group. In the picture, for Supplier1, Cost, PErformance, and Recommendation are larger than the population, and the largest fo those 3 is Cost. The end goal here is to use these numbers to put into an advanced card.
Hi @Anonymous
Finally, you want to get a card visual to display the max value, right?
For example,
for Supplier1, Cost, PErformance, and Recommendation are larger than the population, and the largest for those 3 is Cost,
finally 20 for Supplier1 Cost displays on the card visual.
Do you have a slicer to select Supplier1, Supplier2....
Does the max value compare among buckets (Cost, Performance, Knowledge, Recommendation) for each Supplier?
Or for different Suppliers?
Best Regards
Maggie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |