Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Nick2
Frequent Visitor

Stacked Column Chart with tables as axis

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

1 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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3

@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.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Hey @Seth_C_Bauer,

 

so here it comes:

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

Bsp1.JPG 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.

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

Bsp2.JPG

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

Modify the legend order

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors