Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create combo chart with 2 X-axis

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?

 

Need Help
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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.

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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.