How create a one stack graph with different column data.

[toovishant]

Hi Team,

I have a data set where each Month/Quarter data are in column

Below is the sample table with quarter (there are other fields, but for required view these are column for different regions), I am trying to achive below stack graph

Region	Sum of Q1 Total (USD)	Sum of Q2 Total (USD)	Sum of Q3 Total (USD)	Sum of Q4 Total (USD)
Americas	$52896629	$49480039	$54024820	$53012282
APJCI	$39772305	$41140144	$40410524	$40204964
BMO	$3643635	$2539831	$2525229	$2401644
EMEA	$35138313	$32716731	$32668598	$31561920
Global	$2599363	$1894982	$1596945	$1596945
WE	$4362102	$4694052	$4440694	$4285831

The different legends represents regions sum for each quarter. Please help.

Thank You

[Arul · Accepted solution]

@toovishant ,

I did some changes in structure of the data(Unpivot Columns). Please refer the attached file.

[toovishant]

@Arul - I cannot change the structure of the data set, it has other column fields in this table. But you mentioned something intersting on Unpivot can you shed more information on how can i use unpivot to change the data structure.

[Arul]

@toovishant ,

Check here - https://learn.microsoft.com/en-us/power-query/unpivot-column

[toovishant]

@Arul - Apperciate your quick help and this helped a new features in the power BI. Thank you

[Bibiano_Geraldo · Accepted solution]

Hi, One solution i have its you re-model the data following this steps:

1- in your power query Select the quarter columns as shown bellow:

2- Unpivot Columns:

3- Now your table, should look like that:

4- Close power query and Apply changes

5-Add stacked bar chart, in your x-axis add the quarter column, y-axis add the value column, and in the legend field add the Region.

If this answer help you, please mark it as solution.

[toovishant]

@Bibiano_Geraldo - Thank You, the step by step guide help me and definitly like me who are new to unpivot features.

[Arul · Accepted solution]

@toovishant ,

I did some changes in structure of the data(Unpivot Columns). Please refer the attached file.