Forum Discussion
Helper IICombo 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 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.
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.
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.
4 Replies
v-henryk-mstfCommunity Support
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_LIMv-henryk-mstf
Oh ya..... Just noticed show items with no data. Thanks alot!!!
- amitchandak
Super User
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