Edit legend/ format axis?

[jennys]

Two-part question.

1: I have several charts that show the output line, and a target line. The legend shows the names of both (e.g. "% of output timely, timeliness target"). I would like to keep the names of the measures, but edit the legend so it reads "% of output timely, target." Is it possible to edit the legend without renaming the measures?

2: The x axis, which shows dates, is inconsistent/random with which dates it shows. Can I fix it so that it shows dates at a specified interval? Right now it only seems to add/remove dates as I resize the charts larger or smaller, and even then I cannot choose which dates are shown. In column graphs, the dates shown below the columns don't match the actual date that column shows. Is this able to be edited?

Thank you in advance.

[JosiendeBie]

This has now been fixed. You can doubleclick on the variable in the visualisations tab and it will let you rename it. 

[v-qiuyu-msft · Accepted solution]

Hi @jennys,

#1. Currently, we are able to custom Legend Name rather than legend values. For your requirement, you can vote on this same idea: custom legend.

#2. You can try to create a calendar table, create a relationship between this new table and fact table. Drag the date column from calendar table to chart X-Axis.

Best Regards,
Qiuyun Yu

[MattAllington]

1. Unfortunately not. There is no custom label like in Excel as yet. You can vote for it at ideas.powerbi.com

2. There is a formatting option that allows you to set a continuous or categorical axis. It is in the formatting area I think. Try to swap that and see if it does what you want

[jennys]

Thanks. I had tried the categorical option earlier, but it shows every single date available instead of a select few at a regular interval (makes sense for a categorical variable). Is that the only other way you know of?

[ElliotP]

In terms of Question 2. Your best option for the moment if the continuous/categorical option isn't working for you is to FORMAT the date to the required format and then Sort this by a column in the date table (any that will accept) as so it's properly in order.