Data is in row and need to create chart of it

[ajitrikibe]

Hello All,

My data is in rows,

For eg. I want to create chart for IJP process1 for x company,b company ,z company,r compnay and so on. 

How to create chart for such data ?

particulars	Answer in	x company	b company	z compnay	r compnay	e compnay	s compnay
IJP Process 1	0/1	0	0	0	0	0	0
IJP Process - Please certify if the criteria of Panel was adhered while interviewing the candidates	Y/N	No	No	No	No	No	Yes
No. of STOE Trained	No.	0	0	0	0	0	1
No. of STOE Deployed in Respective Department	No.	0	0	0	0	0	1
OE Buffer(%)	%	0%	1%	5%	8%	6%	0%
ERM - Date of Meeting	Date	1/22/2018	2/15/2018	3/20/2018	4/27/2018	5/10/2018	6/21/2018

[v-juanli-msft · Accepted solution]

Hi @ajitrikibe

To make the chart more visible, I would change the value 0 to whole numbers.

In query editor, 

1. create a blank query, then write the code in advanced editor

let
    Source = Table1,
    newsource=Table.SelectRows(Source,each[particulars]="IJP Process 1"),
    #"Unpivoted Only Selected Columns" = Table.Unpivot(newsource, {"x company", "b company", "z compnay", "r compnay", "e compnay", "s compnay"}, "Attribute", "Value"),
    #"Changed Type" = Table.TransformColumnTypes(#"Unpivoted Only Selected Columns",{{"Value", type number}})
in
    #"Changed Type"

Then select "company" columns from x to s, apply "Transform"->"Upviot only selected columns"

Please note, before "colse &&apply", you need to change the "value" column to "number" data type instead of "text" by default.

Then in the report view,

Best Regards

Maggie