Create combo chart with 2 X-axis

[Anonymous]

Hello all,

I wanted to create combo chart with quarterly average on line chart and monthly sales on column chart .When I plot quarterly average , it shows all 12 values calculated for each month.But I want to see only 4 quarterly values in the line chart. Is it possible to achieve?

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Currently,PowerBI doesn't support to create combo chart with 2 X-Axis.

As a workaround ,you can try to create a measure as below:

Quarterly average of sales =
VAR quarter =
    FORMAT ( SELECTEDVALUE ( Table1[Date] ), "YYYY-QQ" )
RETURN
    CALCULATE (
        SUM ( Table1[ Sales] ) / 3,
        FILTER ( ALL ( Table1 ), FORMAT ( Table1[Date], "YYYY-QQ" ) = quarter )
    )

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.