The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I'm new to the world of Power BI and I'm facing a challenge.
I'd like to analyze the complaint ratio for each customer and visualize it in a nice pie chart. I have two tables at my disposal, where each entry contains a customer number and a year in one table representing orders and complaints in the other table.
In the pie chart, I want to display the percentage of complaints relative to orders for the same time period. The lists COUNT_Complaint and COUNT_Orders have the same structure. I'd also like to be able to filter by customers and year.
I already am able to calculate the overall complaint ratio and, after filtering for individual customers, using a measure (Measure 1 = COUNTROWS('COUNT_Complaint')/COUNT_Orders*100), but I'd like to view them all simultaneously in one chart.
Thank you very much for any help!
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
11 | |
7 |