Forum Discussion
Post PatronPie 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.
Super UserHi,
A pie can only be created from 2 columns. In PQ, select the first column, right click and select Unpivot other columns and click on Close and Load. Now apply your filters and create a pie chart.
inglexjcIs there a visual that will do what I'm needing?
Right if I do a normal filter I'm only left with one response. Is there a visual that will show each column response that meets that filter without being canceled out from the other filters? They are wanting to show this all in one visual.
Income Type <> null
Is rent correct? <> null or Yes
Are utilities correct? <> null or Yes
Are other expenses correct? <> null or Yes
Are there other errors? <> null or no