Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
@Anonymous , My Advice would be to unpivot the QA Columns
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |