Forum Discussion
Combo chart didn't show expected result
- 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.
- 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.
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_LIM5 years agoHelper II
v-henryk-mstf
Oh ya..... Just noticed show items with no data. Thanks alot!!!