Forum Discussion

XIOFEN_LIM's avatar
XIOFEN_LIM
Helper II
5 years ago
Solved

Combo chart didn't show expected result

HI guys,   Do you all face this issue before? When the 2 value fields are swapped in combo chart, the result for target showing differently. Then actual values are BaseAmt has 3 mths record and ta...
  • amitchandak's avatar
    5 years ago

    XIOFEN_LIM , Not sure, But I think the first y-axis measure controls the x-axis range.

    Check this. Switch off the secondary axis and try, if you get 12 months, this can be the reason.

  • v-henryk-mstf's avatar
    5 years ago

    Hi XIOFEN_LIM ,

     

    According to the question you asked, the main reason is that in the screenshot on the left, only the BaseAmt fields corresponding to the three months of Nov, Dec, and Feb have values, and the other months show empty values. Therefore, when the BaseAmt field is placed in "Column values", only the columns corresponding to three months have specific values, and the values corresponding to other months are empty, so the histogram will not be displayed. Leads to the result on the right. 

    I did the following test and set the MonthName field to "show itmes with no data", then all months can be displayed on the x-axis:


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

    Best Regards,
    Henry

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