Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
kjartank
Helper II
Helper II

Yet another 100% stacked bar chart question.

‎06-15-2017 01:42 PM

Hi

 

I have lots of columns that contain the same 3 textual values "Satisfied", "Neither" and "Dissatisfied". Can it be that I have to make a 100% stacked bar chart for each one of the columns?

Labels:
Message 1 of 8
2,365 Views
0
1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion
In response to kjartank

‎06-21-2017 04:14 PM

@kjartank

 

Hi, Create a New Table (Modeling --New Table) 

 

TransformTable =
UNION (
SELECTCOLUMNS ( Table4, "Attribute", "Purchase", "Answer", Table4[Purchase] ),
SELECTCOLUMNS ( Table4, "Attribute", "Locale", "Answer"; Table4[Locale] )

............................(WIth your others Columns)


)

 

Now in the visual add like this:

 

Chart.png




Lima - Peru

View solution in original post

Message 6 of 8
2,873 Views
7 REPLIES 7
v-sihou-msft
Employee
Employee

‎06-20-2017 03:08 AM

@kjartank

 

In your current dataset, since you have one column for each category, you can't have it show all categories in a 100% stacked bar chart.

 

For your requirement, you have to change your dataset into 2 rows, one for category (Purchase, Check-out, etc), the other column for result (satisfied, unsatisfied, etc). Then you put the Category column on X-axis, put Result coumn on Legend. Create a measure like "COUNTROWS()" as Values. It will return your expected result.

 

Regards,

Message 4 of 8
2,335 Views
0
kjartank
Helper II
Helper II
In response to v-sihou-msft

‎06-21-2017 03:46 PM

@v-sihou-msft

 

If I'm not sure I understand it correctly. Do you mean that I should make another table, that looks something like this?

 

PurchaseSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
Check-outDon’t know/ doesn’t applyDissatisfiedDissatisfiedDissatisfiedDissatisfiedDissatisfied
LocaleSatisfiedSatisfiedSatisfied SatisfiedSatisfied
ServiceSatisfiedSatisfiedDissatisfiedSatisfiedSatisfiedSatisfied
InformationSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
CleanlinessSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
PurchaseSatisfiedSatisfiedNeitherSatisfiedDon’t know/ doesn’t applySatisfied
Check-outSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
LocaleSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
ServiceSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
InformationSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
CleanlinessSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
PurchaseSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
Check-outSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
LocaleSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
ServiceSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
InformationSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
CleanlinessSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
PurchaseSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
Check-outSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
LocaleSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
ServiceSatisfiedSatisfiedDissatisfiedSatisfiedNeitherSatisfied
InformationSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
CleanlinessSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
PurchaseSatisfied SatisfiedSatisfiedSatisfiedSatisfied
Check-outSatisfiedDissatisfiedSatisfiedSatisfiedSatisfiedSatisfied
LocaleSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
ServiceNeitherSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
InformationSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
CleanlinessSatisfiedNeitherSatisfiedSatisfiedSatisfiedSatisfied
PurchaseSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
Check-out      
LocaleSatisfiedSatisfiedSatisfiedSatisfiedDon’t know/ doesn’t applySatisfied
ServiceSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
InformationSatisfiedSatisfiedSatisfiedNeitherSatisfiedSatisfied
CleanlinessSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
PurchaseSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
Check-outSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
LocaleSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedDissatisfied
ServiceSatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied

 

 

I'm not sure how that would work.. Would you mind explaining it a bit more in depth?

Message 5 of 8
2,328 Views
0
Vvelarde
Community Champion
Community Champion
In response to kjartank

‎06-21-2017 04:14 PM

@kjartank

 

Hi, Create a New Table (Modeling --New Table) 

 

TransformTable =
UNION (
SELECTCOLUMNS ( Table4, "Attribute", "Purchase", "Answer", Table4[Purchase] ),
SELECTCOLUMNS ( Table4, "Attribute", "Locale", "Answer"; Table4[Locale] )

............................(WIth your others Columns)


)

 

Now in the visual add like this:

 

Chart.png




Lima - Peru
Message 6 of 8
2,874 Views
kjartank
Helper II
Helper II
In response to Vvelarde

‎06-23-2017 03:40 AM

@Vvelarde

 

If I should want to put a filter on the new table, how would I go about that? I want to filter it by the max value of a particular column..

Message 8 of 8
2,310 Views
0
kjartank
Helper II
Helper II
In response to Vvelarde

‎06-23-2017 03:10 AM

@Vvelarde

 

Thanks a lot! That's brilliant work! 🙂

Message 7 of 8
2,312 Views
0
dkay84_PowerBI
Employee
Employee

‎06-15-2017 02:32 PM

What is your question exactly?

 

One option (I think) is that you can unpivot your columns so that you end up 2 columns that contain the original column name (attribute) and the corresponding value.  Then, you could put the column name column as an axis and the values as values and you would get the aggregation (i.e. count, sum, avg etc.) of the 3 textual values for each point on the axis.  This could be a stacked or regular column chart, or 100% stacked if you want.

Message 2 of 8
2,360 Views
0
kjartank
Helper II
Helper II
In response to dkay84_PowerBI

‎06-15-2017 03:11 PM

The thing is that I can't unpivot them, as they don't show up in my "Edit query" screen. I've written them all, using "SWITCH", from columns with numeric values. The question is basically if I can get more than one column in a chart. I have no problems making one like this.

Stackedsingle.png

 

 

 

What I want to acheive is getting more than one bar in the chart, as I have 11 that I need to visualize in the same space.

 

This is what my data looks like. (+  many rows)

 

PurchaseCheck-outLocaleServiceInformationCleanliness
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
Don’t know/ doesn’t applyDissatisfiedDissatisfiedDissatisfiedDissatisfiedDissatisfied
SatisfiedSatisfiedSatisfied SatisfiedSatisfied
SatisfiedSatisfiedDissatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedNeitherSatisfiedDon’t know/ doesn’t applySatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedDissatisfiedSatisfiedNeitherSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
Satisfied SatisfiedSatisfiedSatisfiedSatisfied
SatisfiedDissatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
NeitherSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedNeitherSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
      
SatisfiedSatisfiedSatisfiedSatisfiedDon’t know/ doesn’t applySatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedNeitherSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedDissatisfied
SatisfiedSatisfiedSatisfiedSatisfiedSatisfiedSatisfied
Message 3 of 8
2,356 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

View All