Am trying to create a line chart. In that, I setup "Auto" Display units for Y axis and my data ranging from 0 to 300,000. So i expect Y- axis Grid line values should be 100K,200K,300K but am getting values 0.1M,0.2M, 0.3M . How to fix this? (I cant use custom Display units to Thousands or Millions as i have varying data ranges for different filter selection)
Hi @agguru ,
Please try the following methods and check if they can solve your problem:
1.Create the simple table.
2.Select the line chart.
3.Drag the Date into the X-axis. Drag the Fiscal into the Y-axis and drag the name into the Legend.
4.In the Visualization pane, click on the Format pane. Expand the Y-axis section and set the display units to auto.
5.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @agguru ,
Please try the following methods and check if they can solve your problem:
1.Create the simple table.
2.Select the line chart.
3.Drag the Date into the X-axis. Drag the Fiscal into the Y-axis and drag the name into the Legend.
4.In the Visualization pane, click on the Format pane. Expand the Y-axis section and set the display units to auto.
5.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
