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 really need help.
In my data set there are 2 columns. No zeros in these columns but my line graph in Power BI shows zero for one line. Pictures are attached. I use average and data is by year and month. For example for February 2022: two graphs should show 7 and 2 but they show 7 and 0.
Any idea on how to make Power BI to show actual values instead of zeros on graph?
Thank you!
Solved! Go to Solution.
Hi, @Glibberg
I tested with the data you provided and failed to restore your problem. Here is the result of my test.
I wonder if it has something to do with this in your picture. You can check it out.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Glibberg
I tested with the data you provided and failed to restore your problem. Here is the result of my test.
I wonder if it has something to do with this in your picture. You can check it out.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What is your Y Axis field?
Main Y: average on_hand_inv
Sexondary Y: average proposed_on_hand
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 |
|---|---|
| 98 | |
| 72 | |
| 50 | |
| 48 | |
| 42 |