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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors