Two datasets one bar chart

[hmeltonPSL]

I have two queries from 2 different db tables.  I created bar charts for each.  Each bar chart has the same x axis,  I would like to merge the two bar charts togther into one chart. So the chart would be showing two different bar colors for each dataset.  Is this possible?  Thanks

[Uzi2019]

Hi @hmeltonPSL 
Create relationship between 2 table then take tornato chart to represent 2 coulmn in single chart or you can take stack  bar chart.

Tornado Chart in above example.

I hope I answered your question.

[Anand24]

Hi @hmeltonPSL ,
Create a relationship between both tables on common field (Department in your case) and then pull both KPIs (# Requests and # Workorders) in a clustured bar chart visualization's X-axis.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn