Apply enum with Pivot table web widget

0
If the axis is selected as an Enum, I think it should have a function to display all enum values expanded across the columns (regardless of whether each enum item is used or not).   Is it possible ?
asked
1 answers
0

Hi Udompon Udomvanit,

 

In Mendix, when you use an enumeration attribute as an axis (for example in a chart or pivot grid), the platform will by default only render the enum values that are actually present in your dataset.

  • There is no built‑in option to automatically expand and show all enum values across the axis regardless of usage.

  •  If you want all enum values displayed, you need to pre‑populate your dataset with placeholder rows for each enum item, or build a helper entity/microflow that generates one record per enum value before feeding it into the widget.

  • This way, the chart/grid sees every enum value and renders them, even if the “real” data doesn’t contain that value.

answered