Forum Discussion

FeridChatti's avatar
FeridChatti
Regular Visitor
1 year ago
Solved

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?

 

 

Thank you in advance for your help!

Need Help
  • FarhanJeelani's avatar
    FarhanJeelani
    1 year ago

    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.

2 Replies

  • FarhanJeelani's avatar
    FarhanJeelani
    Super User
    1 year ago

    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.