cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

Does combo chart have group by color function ?

emily02
New Contributor

Does combo chart have group by color function by specific field (type)?  
Like 

Line Chart: the line will perfectly split into multiple lines of different colors, with each line representing a distinct Type.

Bar Chart: The original single bar will also automatically transform into a Stacked Bar chart using different colored blocks to represent for each Type.
like what we have in tableau 

 

 

 

 

 

1 REPLY 1

Ashwin_DSA
Databricks Employee
Databricks Employee

Hi @emily02,

No. You can't. Combo charts in AI/BI Dashboards do not support Tableau-style grouping by a categorical field such as Type. That means a combo chart can combine bar and line series and colour by metric series, but it will not automatically split a single line into multiple colored lines by Type, or turn a single bar series into stacked or grouped bars by Type within that same combo chart.

For reference, the public documentation for AI/BI dashboard visualization types shows combo charts as a combination of bar and line series, with the example using Color by Y-Series rather than colour by a categorical field. The broader chart options documentation also notes that not every configuration option is available for every chart type, even though group by is generally available for many charts.

If you need this pattern, the usual workaround is to reshape the data in SQL so each type becomes its own series, or to use a custom visualization with Vega-Lite when you need more Tableau-like layering and control.

Hope this helps.

If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.

Regards,
Ashwin | Delivery Solution Architect @ Databricks
Helping you build and scale the Data Intelligence Platform.
***Opinions are my own***