Pie chart to show data from different columns with certain filters

Hello inglexjc,
Thank you for reaching out to the Microsoft Fabric Community Forum. I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it.


Visuals like Pie Chart, Bar/Column Chart, or Matrix will show exactly what you need, but only if you unpivot the data in Power Query and use a DAX measure. This ensures that all check types and responses are evaluated properly in the same visual.

For your reference, I’m also attaching a .pbix file so you can review the applied logic and visuals directly.

Best Regards,
Ganesh Singamshetty.

Hello inglexjc,
I tested your revised logic, and I am seeing the same result you shared only “Are there other errors?” appears in the visuals. This happens because, in the current dataset, all values for Rent, Utilities, Expenses are "Yes" or blank, and your condition requires them to be "No" to be counted.

So, the measure is working as expected it’s just that the sample data does not contain "No" values for those checks.

Best Regards,
Ganesh Singamshetty.