Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
I have found the solution in the article
Regards,
Vitalii
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
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
I have found the solution in the article
Regards,
Vitalii
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |