cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ajnewbs23 Frequent Visitor
Frequent Visitor

How do I group the display of x-axis labels as shown

Hi

 

I have a bar chart with two x-axis columns - one a Year and one a Description, how do I make it more legible by grouping the labels by Year as shown in my second example;

My Example.pngMy chartRequired Result.pngRequired x-axis display

5 REPLIES 5
Super User
Super User

Re: How do I group the display of x-axis labels as shown

@ajnewbs23

 

In Format of the Visual in X Axis Put Concatenate Labels to OFF.

 

Regards

 

Victor




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




ajnewbs23 Frequent Visitor
Frequent Visitor

Re: How do I group the display of x-axis labels as shown

Hi

 

Thank you for your reply.

 

Unfortunately setting the Concatenate Labels to OFF made no difference to my graph.

Community Support Team
Community Support Team

Re: How do I group the display of x-axis labels as shown

Hi ajnewbs23 ,

 

Could you share your pbix file with some dummy data?

 

Regards,

Jimmy Tao

ajnewbs23 Frequent Visitor
Frequent Visitor

Re: How do I group the display of x-axis labels as shown

Hi Jimmy

 

Thank you for your response - hopefully this will work - https://www.dropbox.com/s/avqqy26fevvkefy/Test%20Data%20Report.pbix?dl=0

 

Regards

 

mandy

Community Support Team
Community Support Team

Re: How do I group the display of x-axis labels as shown

Hi ajnewbs23,

 

Just delete quarter, month and day in the date hierarchy can't work. As a workaround, you can create a new [Year] column and drag the [Year] column to the stack chart and check if concatenate can work.

 

Regards,

Jimmy Tao