1 of 1 people found this helpful
You're right that you'll need separate measures for each year to get a bullet chart comparison. I'm sure that there are other ways to set this up, but I've chosen the following approach:
1. Create the following fields for First Year Sales and Last Year Sales:
I put the year field in the view. By wrapping each of these fields in a WINDOW_MAX(), it gives me the same output for every year. Then a simple year filter will leave only one year:
Gives the following output:
I've attached my workbook. Let me know if this helps.
Please find sample workbook
See Calculated Measure
Sales Year 1
Sales Year 2
Comparison Year 1
Comparison Year 2
Let me know if this helps or if you need further assistance.
Year Comparison.twbx 1.2 MB