Forum Discussion
How to group data on the X axis?
- 3 years ago
I have found the solution in the article
Regards,
Vitalii
- 3 years ago
Can you follow the below steps?
You must need three columns to achieve this,
required columns are,
1. Year2. 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
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