Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.