Small Values Not Displayed in Combined Line and Stacked Column Chart

[FeridChatti]

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!

[Anonymous]

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

Best Regards

[FarhanJeelani · Accepted solution]

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.