I am only new to power bi so i am still learning.
I was hoping someone could help me with combinding two queries (that have the same column names, just different dates) into one bar graph. I have selected the same fields and selected bar graph. If i only have one option choosen (such as car) the graph shows the totals for each query for car. If i choose more fields to compare (such as car and other). One of the query totals is the full total for all options.
First graph is with one resource (car)
Second graph is when i add more then one resource (car and other)