Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Bar chart Last year vs detail current year



Is it possible to have a chart like the one on the image? There is one bar for the previous year (selected year -1) and 4 bars (one per quarte for selected year). All data (dates and sales amount) are on the same table.




Chart exampleChart example

Community Support
Community Support

Based on your description, you want the chart to change dynamically with the selected year. As far as I know, we can't do it at this stage. It can only use the dynamic axis, but now measure can't be used as the axis.

Super User
Super User

If it were a static chart, you could do it with a calculated column on your Date table.  But to make a dynamic visual (responds to year selection), you likely need to build it with the Charticulator visual so you can use a measure on the axis.

(15) Austin Power BI User Group - Charticulator 101 - YouTube




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

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.