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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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?
@ElaheJ , My Advice would be to unpivot the QA Columns
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!