Line Chart with total bar at the end

[Wellingtonluis]

Hello guys. Any tip do make a chart like this ?
Thanks in advance.

[Anonymous · Accepted solution]

Hi @Wellingtonluis ,

According to the screenshots, it seems that you want to display value of each month by Line visual and display the total value whole year by Stacked Column visual, right?

If so, please follow these steps:

1. Add a measure for total value and display it using Stacked Column chart(disable visual title and X-axis title):

total = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Date].[Year]))

2. create Line chart (disable the X-axis title)

3. Group these two visuals:

Or use Waterfall chart like this:

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

[mahoneypat]

The Charticulator visual is great for making your own combined visuals like this.  There is some learning curve, but well worth it for flexibility in no-code visualization.

(10) Charticulator: Now a Power BI Custom Visual! (with Daniel Marsh-Patrick) - YouTube

Pat

[Wellingtonluis]

Thanks aj1973, could you give more datais about your solution, because for me it seems like one chart.

[aj1973]

@Wellingtonluis  Would you send me a sample of your model and i will give it a try!

[aj1973]

Hi @Wellingtonluis 

You can put 2 visuals on top of each others, one for line chart and another for Total Bar.