Customized Label on Constant Line

[pbiuser12345]

Hello,

I have a bar chart that shows customer responses to a set of questions, split by the year in which the survey was conducted (so for Q1, I have this year/last year side by side).  I need to show an average line across all questions only for the current year's responses.

I have figured out how to do this by using a measure and leveraging that measure in a 'constant line' in the bar chart, but the data label by default only shows the value.  Is there a way I can customize what appears to indicate that it is an average (similar to what would show by default if I added an 'average line' instead)?

Thanks for your help!

[v-zhangti]

Hi, @pbiuser12345 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.