Solved: Re: Pareto Chart for Defects parameters in columns

prady2581 · ‎04-24-2019

hello

we check the defects of process and same is marked as defect parameter all arranged in column wise. e.g. Timelines, Incorrect resolution, Ticket notes. Each of these column fields will take up one of the 3 values

YES - means followed all (no issue)

NO - Defect (it is a defect)

NA - Not applicable.

All these data entered in Excel and exported to PowerBI. I want to create a Pareto chart of defects based on the total count of NO for each parameter.

I've attached a sample PIX file. Please help.

v-chuncz-msft · ‎04-26-2019

@prady2581 ,

You may select Unpivot Columns in Query Editor first.

https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎04-26-2019

@prady2581 ,

You may select Unpivot Columns in Query Editor first.

https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.