Combo chart didn't show expected result

[XIOFEN_LIM]

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 target has 12 mths record.

But what I want to display is BaseAmt as bar while target as line but 2nd image showing missing target. 

[amitchandak · Accepted solution]

@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 · Accepted solution]

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.

[XIOFEN_LIM]

@v-henryk-mstf 

Oh ya..... Just noticed show items with no data.  Thanks alot!!!

[amitchandak · Accepted solution]

@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.

[XIOFEN_LIM]

Hi @amitchandak ,

Thank you.
But show or hide for 2ndary y-axis are showing same result.🤔
** actual values are BaseAmt has 5 mths record and target has 12 mths record