Can you provide a sample workbook?
Read "Category" as your case's "Station"
Put Label kin text as attributes.
Only shows Max of Measure values, which limits only "MAX" label.
Superstore_Label_SM_2018.1.twbx 422.4 KB
If you follow Shin's steps in your workbook it should work.
Thanks so much for your response! I was following along until I got to the formulas for Min Category and Max Category. For me, they were created as measures, with the text "(Count)" appended to them, however, once I dragged them onto the Label tile as attr they worked as you've illustrated above.
I am confused by how you were able to display labels for only the max line and not for the average line. I was able to hide them by setting the mark label to never show, which is ok for the visualization but the wrong Station Name is displayed for the tooltip.
I've attached an updated workbook. See sheet 4
Also, this vis only works when the date dimension is set to year (because all of the calculations use the FIXED LoD. Would these these calculations work if I changed them to INCLUDE?
Thanks for the response. I've gotten most of the way but have some questions. See the post above.
Thank you to all who supported me through this problem. For the sake of completeness I'm attaching my final solution.
Ultimately I landed on a hybrid of the solution provided by Shin. The variation I chose enabled more control over the mark labels and tool tip. I used INCLUDE LoD's instead of fixed so that I can easily show more date granularity.
Shin. Your solution, in particular the Min and Max category formulas, was the key to getting me unstuck. Thank you so much.
You are welcome.
Glad that I could help.