cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mlleverino
Helper I
Helper I

displaying two titles under the AXIS

below is my data set.

 

Customer  sales
Cust Acoke70
 pepsi70
 doritos44
Cust Bcake45
 muffins48
 milk39
Cust Cbread48
 jam7
 corn5

 

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?

 

cokepepsidoritoscakemuffinsmilkbreadjamcorn
 Cust A  Cust B  Cust C 

 

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@mlleverino

 

Hi,

 

Step 1:

 

In Query Editor:

 

Step1.pngReplace ValuesReplace ValuesFill Down in Customer ColumnFill Down in Customer Column

Close & Apply

 

2. Step 2:

 

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

 

Ready

 

 




Lima - Peru

View solution in original post

4 REPLIES 4
Vvelarde
Community Champion
Community Champion

@mlleverino

 

Hi,

 

Step 1:

 

In Query Editor:

 

Step1.pngReplace ValuesReplace ValuesFill Down in Customer ColumnFill Down in Customer Column

Close & Apply

 

2. Step 2:

 

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

 

Ready

 

 




Lima - Peru

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.

@mlleverino

 

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




Lima - Peru

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

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors