How can I create horizontal bar chart without measure?

Q&A
,
1

Hi team,

I have data set with contains 2 text fields ( bic and procurement), my end user wants to view as a bar chart, how can I build bar chart using these text fields, could you please help me in this scenario.
Please see the below screen shot of user requirement for your reference

image
image710Ă—636 69.9 KB

Thanks & Regards

Chaitanyakumar N

2

Hello,

Do you just want to disable the label ? you may be able to do that by disabling label show.

To create a bar chart in QuickSight with two text fields (BIC and Procurement), you’ll need to aggregate your data since bar charts require a measure (numeric value) to display.

or do you just want to show the bar with name and same length ? if so then you change teh aggregation to count.

hope this helps.

Cheers,

Deep

1 Like
3

Hi Deep, thanks for your answer, but requirement is like marked circle, see the below screen shot

image
image745Ă—694 62.6 KB

4

Hi @Cnagabhairava ,

Following up here as it’s been a while since last communication took place on this thread; did you have any additional questions regarding your initial post? Or if the still having troubles with what you are trying to achieve in your initial post, may you provide further details into the topic.

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

5

Hi @Cnagabhairava , You can create horizontal bar charts with text fields using QuickSight’s automatic count functionality. The system will count occurrences of your categorical data combinations without requiring numerical measures.

For detailed guidance on creating bar charts with text fields, see: Visual types in Amazon Quick Sight - Amazon Quick Suite

Please let me know if you have any questions.

Thanks.

6

Thank you for your answer.

7

Thank you for your answer.