Combo Chart, Monthly bars with Quarterly line, possible?

[katto_16]

I want the line component to only show quarterly total numbers even though my x-axis is by month. Is this possible? 

[Anonymous · Accepted solution]

Hi @katto_16 ,

I think it is possible to achieve your requirements.

First of all, I create a table as you mentioned.

Then I create two calculated columns.

Format =
YEAR ( 'Table'[Date] ) & "-"
    & FORMAT ( 'Table'[Date].[Quarter], "00" )

QtrTotal =
CALCULATE ( SUM ( 'Table'[Total] ), ALLEXCEPT ( 'Table', 'Table'[Format] ) )

Finally you will get what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.