Forum Discussion

VitaliiCH17's avatar
VitaliiCH17
Frequent Visitor
3 years ago
Solved

How to group data on the X axis?

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

 

Need Help
Tips and Tricks
  • Arul's avatar
    Arul
    3 years ago

    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

2 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    3 years ago

    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