This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Bar Chart not showing bars in desired order

Posted Tuesday
MayaE
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hi!

I want my bar chart to display the bars in the following order from left to right: Very Satisfied, Somewhat Satisfied, Neither satisfied nor dissatisfied, Somewhat dissatisfied, and Very dissatisfied. Since my data is text, I went back to my Google Sheets where I have my raw data and added a column to number each data point in column B2:

Google Sheets column (this shows only part of the column as an example):

looker_studio_overall_satisfaction_formula.png

Google Sheets formula:

looker_Studio_google_sheets_formula.png

However, my bars are still not showing up in the order I specified in my Google Sheets formula. It looks like this:

looker_studio_bar_Chart_wrong_order.png

  • Dimension - set to the right survey question
  • Metric - Record Count
  • Sort - column from Google Sheets that quantifies my text data. I also have it set to Ascending order 

I have asked Gemini for help and have trouble shooted but no luck. I'm hoping someone can help me figure out what the underlying issue is. Thank you! 

0 0 42
Topic Labels
0 Likes
0 REPLIES 0