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!
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
