Forum Discussion
Anonymous
3 years agoNot applicable
Matrix with qualitative value
Hi,
I have a table like this for quality chech with different criterias for assessments. and I need to know for each criteria how many of them are satisfactory and not satisfactory. my table is like below which shows the restult for each ID and each criteria.
and the result I'm looking for is sth like this which I created in excel.
I'm quite confused how can I make that visual in power bi?
1 Reply
- amitchandakSuper User
Anonymous , My Advice would be to unpivot the QA Columns
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g