"Side by side bars with line chart"

Version 1

    Ever wondered how to create  side by side bars with a line chart??

    This can be achieved by some work around. Start by writing a custom sql to pivot the measures. create aliases for the measures as " Measure names" and "Measure values". Give the specific mark types for the measures.

    Write 2 calculated fields(one for bars and one for line). 

    Finally in order to show bars side by side with line chart, create a date field using calculation field as mentioned in the workbook.

    Drag created calculated date field to rows, bars and lines to columns. change the view to dual axis.

     

    For detailed calculations refer to the workbook attached .