The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |