Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Line and column chart on same axis

Hello everyone,

 

I have some unusual issue. Please take a look below:

The chart above is standard line and clustered column chart. The question is, is there any way to move two lines from the bottom of the chart to the left axis ?. In other words, I want to combine a column data (red + green columns) with red + green lines and put on the same axis (left). On the other side, I want to keep orange line on right axis.


The goal I want to achieve is:

I made this by creating two separate charts and hiding a background of one of them (blue line is actually a separate chart). However this scenario I want to avoid.

Would be grateful for any tip and hits.

 

3 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion

    You could do this with the custom visual CHARTICULATOR. Do you have sample data?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello Paul, thank you for tip. I already downloaded CHARTICULATOR but it seems I would need some tutorial/ YT as it more advanced than standard chart in powerBi. Anyway, do you see any workaround but exluding CHARTICULATOR ? 

      • PaulDBrown's avatar
        PaulDBrown
        Community Champion

        There may be other more straightforward custom visuals in the store. You cannot achieve this with the standard PBI visuals.