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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.