cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBuddy1
Frequent Visitor

Chart with Combinations

How can I create a chart which shows below - 

 

1) Single Bar on left showing Last Year - Year to date Sales (based on which year is selected from year slicer)

2) Single Bar on tright showing Current Year - Year to date Sales (based on which year is selected from year slicer)

3) In between line chart showing month wise Sales (based on which year is selected from year slicer)

 

Capture.PNG

 

Please advise.

5 REPLIES 5
mahoneypat
Microsoft
Microsoft

This chart could be created with the Deneb visual by using "hconcat" to combine the 3 charts into one visual.

Getting Started | Deneb (deneb-viz.github.io)

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


@mahoneypat can you pls advise how I can achieve it using deneb chart?

PowerBuddy1_0-1651403018233.png

 

AllisonKennedy
Super User
Super User

@PowerBuddy1  This will look different than your picture, because the scale for month will be much smaller than the YTD. What does your data model look like with relationships? You will need a DimDate table for this one: https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html 

 

Then you can create measures to change between the selected year and last year:

 

Total Sales = SUM( Sales[Sales] )

YTD Sales = CALCULATE ( [Total Sales], DATESYTD( dimDate[Date] ) )

Prior YTD Sales = CALCULATE( [YTD Sales], DATEADD( dimDate[Date], -1, YEAR) )

 

Then use them in a column chart with Month. 

 

I would recommend a card visual for the YTD totals.


Please @mention me in your reply if you want a response.

Check out my Olympics report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Thanks @AllisonKennedy but the client requires it in a chart not slicer based.

 

Any idea?

 

With this it gives me YTD and YTD LY per month.

 

Whereas it needs to be consolidated two bars at the end and in the center a line chart for MTD values.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors