How to get two dimension on same scale(x- axis) on sense bar/line chart

[krishnadwivedi]

Dear All,

Hope every one is fine and healthy!!!

I need to create one Bar and Line graph, and requirement is like (Image attached) two dimension on same scale(X- Axis).

1- In 2014,2015,2016 Etc Year, four quarters are there(Q1, Q2,Q3,Q4)

Requirement is like- 

Year and Quarter should show as dimension as below format, How to achieve Year and Quarter in below graph pattern.  

and 

So on above, these dimension should show like this. I have tried with many option like drill down, addition of two dimension and many more ways. But did not able to get the result with this format of chart.

Please help me on this to get as above format result.

Note: - Apart from this two dimension on same scale as single dimension, we need to use another dimension too. 

Thanks,

Krishna Dwivedi

[krishnadwivedi]

Hi All,

Please suggest me on this, if any solution are available for same requirement. 

Regards,

Krishna Dwivedi

[balabhaskarqlik]

Some times it requires to combine some fields and create a new field (or Composite key), bcz all charts won't support 2 dim's on same axis.

Combine the required fields like : Year &'-'& Quarter as YearQuarter

[krishnadwivedi]

Hi balabhaskar,

Thanks for your time on this and reply, As you suggested to combined two fields. I have tried and get as require format result. The requirement is to show quarter and year as same on image. Please let me know if any other option is available. Thank you.

I have tried and getting below format and as required.

But requirement is like as below format, first Quarter and then Year should come as shown in pic.- 

Regards,

Krishna Dwivedi