Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
FeridChatti
Regular Visitor

Small Values Not Displayed in Combined Line and Stacked Column Chart

Hi everyone,

I am facing an issue with the combined Line and Stacked Column Chart in Power BI. I noticed that small values (either in the line or the columns) are not being displayed on the visual, even though they exist in the dataset.

I suspect it might be related to the scaling or how the axis is managed, but I haven’t been able to resolve it.

Could anyone explain why this happens and suggest how to ensure that all values, regardless of size, are properly displayed in the chart?

FeridChatti_0-1736501071811.png

 

 

Thank you in advance for your help!

1 ACCEPTED SOLUTION
FarhanJeelani
Super User
Super User

Hi @FeridChatti ,

The issue you're encountering is likely due to scaling differences between the primary and secondary axes. Here's how you can address this problem:

Root Cause

  1. Axis Scaling: When small values exist in comparison to larger ones, Power BI may scale the axes in a way that makes small values visually insignificant or completely hidden.
  2. Dual Axis Issue: If you have a secondary axis for the line or column, mismatched scaling between the primary and secondary axes can cause one set of values to appear too small or not at all.

Please try below points:

To ensure that all values are properly displayed:

  1. Use a Logarithmic Scale (If Applicable):

    • A logarithmic scale can help if there's a large disparity between the values.
    • In Power BI, go to the Y-Axis settings and enable the logarithmic scale. However, ensure that this makes sense for your data.
  2. Adjust Axis Ranges:

    • Check the axis range settings for both the primary and secondary axes.
    • Set minimum and maximum values manually to ensure small values are visible.
      • Go to the Format Pane > Y-Axis (Primary/Secondary) > Adjust the range under "Start" and "End."

Please mark this as solution if it hepls you. Appreciate Kudos.

View solution in original post

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi @FeridChatti ,

has provided a comprehensive explanation and effective solutions for your issue. Additionally, I suggest creating a tooltips page as an alternative method. You can refer to the official documentation for guidance:

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

vyiruanmsft_0-1736739032907.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FarhanJeelani
Super User
Super User

Hi @FeridChatti ,

The issue you're encountering is likely due to scaling differences between the primary and secondary axes. Here's how you can address this problem:

Root Cause

  1. Axis Scaling: When small values exist in comparison to larger ones, Power BI may scale the axes in a way that makes small values visually insignificant or completely hidden.
  2. Dual Axis Issue: If you have a secondary axis for the line or column, mismatched scaling between the primary and secondary axes can cause one set of values to appear too small or not at all.

Please try below points:

To ensure that all values are properly displayed:

  1. Use a Logarithmic Scale (If Applicable):

    • A logarithmic scale can help if there's a large disparity between the values.
    • In Power BI, go to the Y-Axis settings and enable the logarithmic scale. However, ensure that this makes sense for your data.
  2. Adjust Axis Ranges:

    • Check the axis range settings for both the primary and secondary axes.
    • Set minimum and maximum values manually to ensure small values are visible.
      • Go to the Format Pane > Y-Axis (Primary/Secondary) > Adjust the range under "Start" and "End."

Please mark this as solution if it hepls you. Appreciate Kudos.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.