1 of 1 people found this helpful
I created a similar chart for you using Sample Superstore data. I saved it to my Tableau Public profile and you can access it using the link below or attachment.
I first created a table of the data and created a Previous Month calculation using Looking (see "@Previous Year Month" calculation). I then used this to calculate the month over month % change (see "@YoY Change" calculation).
I then created the chart with Month of Order Date and Year of Order Date on the columns shelf. I then placed Sales on Rows and changed it to a bar. From here, I needed to add the circles with the percentage change. To do this, I chose a value somewhere near the bottom (I chose $10,000). Next to Sales on the Rows shelf, I double-clicked and typed "Min(10000). I changed this to a dual axis and synchronized the axis. On this Min(10000) axis, I changed the mark type to a shape and used a filled circle. I changed the color to blue. I added the @YoY Change calculation to the Text card (as a label) and centered it.
Wow! Kevin! This is exactly what I was looking for. I will follow these steps for my own data source. Many thanks.
I'm happy to hear that!!! You are welcome.
Would you be so kind to mark this as "answered"? Thank you!