Stacked Column Chart with tables as axis

[Nick2]

Hey Guys,

I want to create a stacked column chart with several different tables. The contain the Name of the object (mostly the same for all tables) and the amount of money used for it. But nothing that I could put in the axis, which is why Power BI always stacks up the amount of money and has all the object names side by side. But what I want is a column for every table. Does anybody know a solution?

Greetings,

Nick

[Seth_C_Bauer]

@Nick2 An example will go a long way to resolve this. It sounds like you would be better off merging the datasets using the Power BI Desktop, but I can't say for certain. It is best to have a sample dataset, visual of what you want to have happen, etc.

[Nick2]

Hey @Seth_C_Bauer,

so here it comes:

Let say I have three budgetreports of a compay that look something like this:

 Now I want to show them in a stacked Column Chart, that seperates every Query. Should look like the left Graph but it does look like the right one, as I only get the report of the values of the Query I dragged in last.

The left graph was achieved by making a list of all reports and adding a number to the time the were created:

So how can I achieve the same result without doing all the work by hand? And Since I'm already asking, is it possible to tell Power BI in which sequence I want the data to be stacked in one Graph?

Thanks for the help,

Nick

[v-yulgu-msft · Accepted solution]

Hi @Nick2,

how can I achieve the same result without doing all the work by hand?

I would say NO. There is no direct way to achieve such a bar chart. You have to combine all datasets into a signle one and add a column to distinguish them.

And Since I'm already asking, is it possible to tell Power BI in which sequence I want the data to be stacked in one Graph?

Please refer to: stacked column chart legend order

Modify the legend order

Regards,

Yuliana Gu