There were a few things I had to do to get this to work on your Bubbles worksheet. First I added your year field to the detail mark. I then created a field called Estimate Rank like this:
I also added this to the detail shelf and set it to calculate at the level of State, restarting every year
I then created two label fields using this rank calc, one called State Label:
if [Estimate Rank] <=5 then attr([State]) end
and one called Estimate Label:
if [Estimate Rank] <=5 then attr([Estimate]) end
I changed the State field from text to detail, and added both label fields to the label mark
Then i selected "Allow labels to overlap other marks". Now it'll only show the top 5 labels and it'll update based on the year selected on the dashboard. Format the font and font size as needed.
All of this is in the attached workbook. Let me know if you have any questions.
migration (1)_v10.5.twbx 25.1 MB
That worked. Thanks for the help Paul.
Welcome! Happy to help