Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
93 | |
83 | |
77 | |
72 | |
66 |
User | Count |
---|---|
115 | |
103 | |
93 | |
64 | |
61 |