How to group data on the X axis?

[VitaliiCH17]

Hi,

In my report, I have a bar chart with Year-month on the X axis, but values are presented in YY/MM format.

I would like to present them in a 'grouped' style as on the screen below:  

I can't find any guide to do this.

Could you please help to solve the problem?

Regards,

Vitalii

[VitaliiCH17 · Accepted solution]

I have found the solution in the article

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-customize-x-axis-and-y-axi...

Regards,

Vitalii

[Arul · Accepted solution]

@VitaliiCH17 ,

Can you follow the below steps?

You must need three columns to achieve this,

required columns are,
1. Year

2. Quarter

3. Monthname (It should be sorted based on month number)
then use those 3 columns in X-axis (refer the image attached) and measure in Y axis and do expand all down one level in the hierarchy option at the top right of the visual (refer the image attached).

and to get the solid line on the X-axis, Increase the width of the gridlines (vertical) option (style - solid) from the formating pane (refer the immediate next image attached) ,

Thanks,

Arul

[VitaliiCH17 · Accepted solution]

I have found the solution in the article

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-customize-x-axis-and-y-axi...

Regards,

Vitalii