Hello Experts，
Do you know whether Acumatica dashboards support the following combo chart in a single widget? Looks like belwo chart on the pic.
If not natively supported, please advise on the recommended alternative.
Thank you.
Best answer by Steve Milner
@ray20 Not in a single widget, at least through 2026 R1. A chart widget takes one Chart Type, one Categories field, one Series field, and one Value field with one aggregation. There's no combo type and no secondary axis.
The column half works on its own. Use Stacked Column with Categories on your date field (Date Rounding: Months), Series on Inventory ID, and Value on Qty with Sum. Maximum Number of Values Shown defaults to 10 and keeps the largest, so set it to 12 in Categories or your two lowest months drop off. On Series, raise it or tick Show Sum of Other Entries so the small items roll into one block.
For the Sales line, pick one:
- Two widgets are fine: add a Line chart on the same GI with the same Categories settings, no Series, and your sales amount with Sum as the Value. Place it under the column chart. Each widget gets its own axis, so the scale gap stops mattering.
- It must be one visual: build it in Power BI. Its Line and stacked column chart puts the line on a secondary Y axis. Feed it from the same GI through OData, pin the visual to a Power BI dashboard, and show it in Acumatica with a Power BI Tile widget. That needs Power BI and a one-time registration of your instance.
+4@ray20 Not in a single widget, at least through 2026 R1. A chart widget takes one Chart Type, one Categories field, one Series field, and one Value field with one aggregation. There's no combo type and no secondary axis.
The column half works on its own. Use Stacked Column with Categories on your date field (Date Rounding: Months), Series on Inventory ID, and Value on Qty with Sum. Maximum Number of Values Shown defaults to 10 and keeps the largest, so set it to 12 in Categories or your two lowest months drop off. On Series, raise it or tick Show Sum of Other Entries so the small items roll into one block.
For the Sales line, pick one:
- Two widgets are fine: add a Line chart on the same GI with the same Categories settings, no Series, and your sales amount with Sum as the Value. Place it under the column chart. Each widget gets its own axis, so the scale gap stops mattering.
- It must be one visual: build it in Power BI. Its Line and stacked column chart puts the line on a secondary Y axis. Feed it from the same GI through OData, pin the visual to a Power BI dashboard, and show it in Acumatica with a Power BI Tile widget. That needs Power BI and a one-time registration of your instance.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
