Hi, I am new to quicksight ,I working on the some visualization , I am facing some difficult , please help me out. I have a data like this. FY 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 scope 1 250 243.31 Mt-CO2 224.17 Mt-CO2 223.81 Mt-CO2 214.43 Mt-CO2 195.40 Mt-CO2 194.…

You have to unpivot your data to make it look like this first: [image] Select “Stacked vertical bar chart” as your visual type, put “Year” on the x-axis, “Emission Amount” in value and “Scope” in Group/Color.

Hi, @suresh1 . Welcome to the Quick Sight Community, and thanks so much for posting your question! :slight_smile: Due to the US holiday, our team will review this question on Monday. In the meantime, we encourage anyone form the Community to reply.

@suresh1 We hope the solution from @David_Wong worked for you. Let us know if this is resolved or if you still have questions. Thanks!

Thanks @Kristin and @David_Wong , I changed the data into the above format manually and I got the visual. I tried to change the data with the Pivot table, but I didn’t get what I am expecting. Would please refer me to any blog to change the data into the above format using an excel pivot table.

How to visualize the two value in row into Y axis

Q&A

EvaB December 2, 2022, 12:05pm 6

@suresh1
You need to unpivot your data, not pivot.
You can try this tutorial : Unpivot Excel Data - Excel University

Transpose Table

Topic		Replies	Views
Creating vertical table wth different rows Q&A quick-sight , calculations , Business-Intelligence-Engineer	5	354	January 29, 2024
Filtered column plot Q&A admin , quick-sight , reports	8	217	December 28, 2023
Can we pivot data in Quick Sight? Q&A formatting , quick-sight , data-preparation	1	1526	March 23, 2022
Separate chart for each row in table? Q&A charts , quick-sight , pivot-table	4	931	September 18, 2023
Transpose Table Q&A data-source , quick-sight	7	2926	December 16, 2022

How to visualize the two value in row into Y axis

Related topics