Stacked and a independent column chart in power BI

+1 vote
Hi, can anyone help how to create a stacked and an independent column chart?

I want to show options other than female and male gender in a stacked chart and female and male gender as individual columns.

Can someone help?
Jun 12 in Power BI by rahul
789 views

1 answer to this question.

+1 vote

Hi Rahul,

Follow the below steps:

1. Create a group with the elements that you need in the stacked column.

Right click on the column and click New Group.

Select the values in field and click on Group. Click ok.

2. Place the created group column in Axis and measure or aggregated column in Values.

3. Drop the column in legend and select vertically stacked column chart.

You can see a stacked column and other individual columns.

Example- 

Hope it helps!.

answered Jun 12 by anonymous
• 32,260 points
Hi,

I need to build the exact chart displayed in your post but I'm not able to group two of the columns that need to be stacked.  Under 'Ungrouped values', instead of showing other fields available in my table, it displays the values from the fields. How did you create the category "Furniture & Office Supplies" under the 'Groups and members' section?

Thank you.

Hi,

You need to group the columns that you want to add as a stacked column and the others add them as separate groups with independent values.

Groups:

Furniture & Office supplies - > Furniture, Office supplies

Technology -> Technology

If possible, can you share a pic of how far you have done? 

I can help you better then.

Hi,

Thank you for your reply :)

I have three columns, CostClaimed, CostApproved & CostForecastApproved.  All three fields are data type Decimal Number.  The two columns I need to group are CostApproved ad CostForecastApproved with CostClaimed being a single column to the right.

I've tried to put everything into on snippet for you.

Thanks again for your reply.

The above solution is to group column values into independent and stacked columns, not different columns to independent and stacked bar chart.

Related Questions In Power BI

+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 17,060 points
2,464 views
0 votes
1 answer

How to rename a column using DAX in Power BI?

Hi Ramya, I found these two function that ...READ MORE

answered Aug 21 in Power BI by anonymous
• 32,260 points
487 views
+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 17,060 points
3,101 views
0 votes
1 answer

Can I create a Power BI report in Office 365 without my locally installed Office Excel?

Yess!! You can achieve this by using ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 45,780 points
97 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
113 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,060 points
790 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 17,060 points
152 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 45,780 points
147 views
0 votes
1 answer

Chart with only some values in field in a graph in power BI?

Hi Banu, While creating a chart, put the ...READ MORE

answered Apr 10 in Power BI by Cherukuri
• 32,260 points
52 views
0 votes
1 answer

Difference between measure and calculate column in power BI

Hi Rahul,  With calculated columns, you can add new ...READ MORE

answered May 16 in Power BI by Cherukuri
• 32,260 points
1,131 views