Forum Discussion

jennys's avatar
jennys
New Member
9 years ago
Solved

Edit legend/ format axis?

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 t...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

jennys's avatar
jennys
New Member
9 years ago

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's avatar
ElliotP
Post Prodigy
9 years ago

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.