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
Datagrl
Regular Visitor

Sorting stacks in a Stacked Bar Chart

Hi All,

 

I'm new to PBI, and am hoping you can help me.  I am visualizing data from a satisfaction survey, and am having issues with a stacked bar chart.

 

My data consists of 14 questions with values on a 5-point scale.  Each question is a column, and each survey is a row.

 

I need to have a stacked bar chart that shows how many people responded with each of the five points, so each stack would include:

 

  • Strongly Agree x #responses
  • Agree x #responses
  • N/A x #responses
  • Disagree x #responses
  • Strongly Disagree x #responses

The final result something like this:

Stacked Chart.JPG

 

I've tried using text values and creating COUNTROW measures for each value per question.  I've tried using numeric values and working with the data that way.  No matter what, all the data just stacks up in one bar, or if I move my data to the Axis section, I get no bars.  I've been searching Google and the Power BI site, but I'm not finding instructions for what I'm sure is a pretty basic action.

 

Help?  Please? 🙂  Thanks in advance - I really appreciate it.

1 ACCEPTED SOLUTION
v-haibl-msft
Employee
Employee

@Datagrl

 

If you survey table is like below. You can select all columns in this table and click Unpivot Columns in Query Editor.

Sorting stacks in a Stacked Bar Chart_1.jpgSorting stacks in a Stacked Bar Chart_2.jpg

 

With above transformed table, we can use the 100% Stacked bar chart to get the expected report.

Sorting stacks in a Stacked Bar Chart_3.jpg

 

Best Regards,

Herbert

View solution in original post

2 REPLIES 2
v-haibl-msft
Employee
Employee

@Datagrl

 

If you survey table is like below. You can select all columns in this table and click Unpivot Columns in Query Editor.

Sorting stacks in a Stacked Bar Chart_1.jpgSorting stacks in a Stacked Bar Chart_2.jpg

 

With above transformed table, we can use the 100% Stacked bar chart to get the expected report.

Sorting stacks in a Stacked Bar Chart_3.jpg

 

Best Regards,

Herbert

@v-haibl-msft ~ This solved my issue.  Thank you!!! 🙂

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.