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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
hjameelq
Advocate IV
Advocate IV

Can we use stacked bar chart that combines 4 dimensions, and each dimension has 3 answers: Yes, No?

Can we use stacked bar chart that combines 4 dimensions, and each dimension has 3 answers: Yes, No and Decline to answer?
 
 
The issue I face here that I have  the following data:
 
 
A B C
Yes Yes No
Yes No No
No No No
Decline No
Decline
 
How can display these different dimensions in one stacked bar chart using either qliksense or qlikview.
 
Regards, -Hanan

2 REPLIES 2
Eric_Zhang
Microsoft Employee
Microsoft Employee

@hjameelq

 

I don't quite get your idea. Can you draw the expected output and upload it? Maybe you're looking for something as below?

Capture.PNG

I got guided to a solution to disagggrate dataset so I can combite 3 different options/columns for one question in one column using unpivoting. 

 

The original output:

 

-Q1 (Multiple Question)

A  B  C, Where a,b,c are options to Q1

 

A  B  C

1   3   5

2   4   5

3   6   6 

 

 

So what I did is to unpivot the data so I can use add more than one column to the chart, I mean as you know it is hard to present three columns in on chart, that is not gonna work!

 

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors