Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi ,
I m new to Power Bi, I want to show both Ontime% line and Target line in line and stacked column chart but both are not showing correctly.Created below measures.
Target=80
Ontime% = DIVIDE(SUM('Table 2'[ontime]),Sum('Table 2'[ontime])+SUM('Table 2'[overtime]))
| Legend | Overtime | Ontime |
| Start_Ct | 1 | 3 |
| Close_CT | 3 | 1 |
Solved! Go to Solution.
@Anonymous , Have taken 80 as value and marked it % column. For % column, you need to take 0.8 for 80%
Thanks its working fine now
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!
| User | Count |
|---|---|
| 97 | |
| 71 | |
| 50 | |
| 47 | |
| 44 |