Forum Discussion
Change legend value label name in Line and Clustered Column Chart
Hi All,
I am currently working on PowerBI report and I am using line and clustered column chart. I am able to represent data the way I wanted. But I want to change the label name for line (currently line will draw based on sum of request column) from "Count of Requests" to "User Requests". I want a custom label name instead of default label that is being named based on type of column and operation. So could you please help how to modify line chart label in the display.
Regards,
Srinu Tamada
7 Replies
AFAIK, there's no way to change the label name, in your case, to get a custom label name, you can use a measure instead.
User Requests = COUNTROWS(request column) OR User Requests = SUM(request column)
Thanks for your response.
It's not a simple count, its more like "count(sals) and group by area". So this solution didn't work.
srinutamada wrote:
Thanks for your response.
It's not a simple count, its more like "count(sals) and group by area". So this solution didn't work.
Can you be more specific? A measure can work according to the groups.
srinutamada Did you come up with a solution for this?
I would like to do something similar i.e. change the legend value label name.
Hi Gary, have a look at my solution here:
https://community.powerbi.com/t5/Desktop/Custom-name-legend/td-p/49047/page/2
I am not able to change legend value but this solution helped me while representing data in the chart with calculated column
AverageIssues = AVERAGE(CustomTasks[Issues])
HI..maybe this has been solved already but for anyone who ran into the same issue this is how it works:
In the visual settings rename the fields for the y-axis column and line in the wells.After that the legend shows the changed values.
Cheers,
Gags
