How to create stacked hierarchical customized bar chart for table data?

[thanga]

Hello Team,

I have the below Table data 

S.No	Description	Count		Module1			Module2			Module3
1	Overall Total Testcase	6000		Total TC	500		Total TC	550		Total TC	300
2	Over all Automation	4500		Automation	400		Automation	450		Automation	0
3	Over all Manual	1000		Manual	50		Manual	40		Manual	50
4	Overe all Yet to develop	500		Yet to develop	50		Yet to develop	60		Yet to develop	250

I need the Power BI report  as below. Could you please help how to create the same in powe BI desktop?

[thanga]

Hello miTutorials,

I have tried the same steps metioned in the youtube video. But i am not able to genrate the report.

Steps:

1. I have loaded the excel into power BI desktop as below.

2. Select the sheet in Right side and click three dot

3. Select Edit query

4. Power Edit query opened as below

5.Selected the column as below

6. Select Transform - unpivoted column drop down- Select option as unpivot only selected column 

7. I am getting output as below.

7. Next click pivot column option we will get as below

8. After click ok. I am getting as below.

From this how to generate the chart. Could you pls provide step by step?

[miTutorials]

Please see the attached PBIX file. You will have to transform the data in Power Query.

Check out this video to learn about Pivot/Unpivot feature.

Pivot/Unpivot PowerBI Feature explained | Power Query | MiTutorials - YouTube