Forum Discussion
Stacked Column Chart with tables as axis
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
Regards,
Yuliana Gu
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.
Hey Anonymous,
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
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
Regards,
Yuliana Gu