Forum Discussion

PowerBuddy1's avatar
PowerBuddy1
Frequent Visitor
4 years ago

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 Curr...
Need Help
AllisonKennedy's avatar
AllisonKennedy
Community Champion
4 years ago

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.

PowerBuddy1's avatar
PowerBuddy1
Frequent Visitor
4 years ago

 

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.