Forum Discussion

Narenthir's avatar
Narenthir
Frequent Visitor
2 years ago
Solved

Line and Stack chart issue

Hello All,
In this picture as you can see Line value is lower than chart value, eventhough line placement above the chart, Any solutions welcome, Help needed. Thanks in advance.

 

  • Hi Narenthir 

    It happens because your column y-axis and line y-axis numbers have different proportions.
    To fix it you can calculate with Dax the maximum value of the columns and put it as a max value on both of the y-axises. 

    I prepared PBIX with the numbers from your image, you can download it from This link 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

3 Replies

  • Hi Narenthir 

    It happens because your column y-axis and line y-axis numbers have different proportions.
    To fix it you can calculate with Dax the maximum value of the columns and put it as a max value on both of the y-axises. 

    I prepared PBIX with the numbers from your image, you can download it from This link 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.