displaying two titles under the AXIS

[mlleverino]

below is my data set.

Customer		sales
Cust A	coke	70
	pepsi	70
	doritos	44
Cust B	cake	45
	muffins	48
	milk	39
Cust C	bread	48
	jam	7
	corn	5

how can i get PBI to graph where my axis is displayed as formated below with the bar graphs extending from each of the categories?

coke	pepsi	doritos	cake	muffins	milk	bread	jam	corn
	Cust A			Cust B			Cust C

[Vvelarde · Accepted solution]

@mlleverino

Hi,

Step 1:

In Query Editor:

Replace ValuesFill Down in Customer Column

Close & Apply

2. Step 2:

Insert a chart and go to lowest level of dataTurn off Concatenate in X Axis

Ready

[mlleverino]

One more question.  How do you add grid line to distinguish between Cust A, B, and C?  the layout is now as i want it, but need to see (with gridline) where Cust A ends and cust b begins.

[Vvelarde]

@mlleverino

For now i think is not possible change the color separator between those.

[mlleverino]

Boom!! that just happened!!  Thank you!!