March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi
Can anyone help with power bi issue..
I have excel file which I have uploaded to power bi now that is quality parameters and scoring excel sheet. My question is i have 19 quality parameters which involves "met" and "not met" in vertical format. That file also includes date of audit, supervisor name, audit count etc ..
I want a visualisation wherein chart should show me "not met %" parameters wise.
Solved! Go to Solution.
Hi @Rahulty ,
I create a table as you mentioned.
I think you can create a calculated column at first.
Column = IF('Table'[Status]="Not Met",1,0)
Measure = DIVIDE(SUM('Table'[Column]),COUNT('Table'[Parameter]),0)
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Rahulty ,
I create a table as you mentioned.
I think you can create a calculated column at first.
Column = IF('Table'[Status]="Not Met",1,0)
Measure = DIVIDE(SUM('Table'[Column]),COUNT('Table'[Parameter]),0)
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Issue resolved ☺️
Thanks buddy it was a great help.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
88 | |
78 | |
65 | |
59 |
User | Count |
---|---|
140 | |
122 | |
105 | |
94 | |
90 |