- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2025 04:36 AM
Hello @amekojc ,
Yes — Databricks AI/BI pivot tables do support showing multiple measure values as columns, not just as a single stacked “values” row.
How to set it up
-
Create a Pivot visualization and add your dimension fields under Rows, and optionally another dimension under Columns, in the editor panel.
-
Add each measure you want under Values (the cell area). Then adjust the Values orientation so the measures are displayed as columns instead of being stacked as a single values row. This capability landed in the December 2024 timeframe, so you should see an explicit option to place multiple measures on rows or columns in the pivot configuration.
A few practical tips
-
If you’re building a very wide pivot (lots of measures multiplied by lots of column groups), keep in mind the pivot limits: up to roughly 1,000 columns by 1,000 rows. Past that, it’s usually better to simplify groupings or split the view into multiple visuals.
-
If your measures are still showing up as rows, double-check the Values orientation setting and confirm your workspace is on a December 2024 or newer release where the “multiple measures on rows or columns” option is available.
Hope this helps, Louis.