How to hide a line in a graph

3294318

I am currently working on a turnover graph that displays the projected turnover and YTD turnover rates in a lines and the total terminations per month in bars. The "Month Only + Year" field I have brought it displays Jan-16, Feb-16 and so forth but when I sort them it shows them alphabetically. I have another field called Month but it displays the date and time and I do not want to display that information so I am trying to use the "Month Only + Year" field. When I add the Month field to the graph, it sorts the graph correctly but adds a line for Month since that is where it seems to work the best for the graph but I do not want to display this line.

So is there a way you can hide a line or is there a way to sort a graph by a column that is not used in the graph?

Below is the graph I have currently but DO NOT want the read line to display.

Gianni Ceresa

Double posting with How to sort by a column not used in a graph

Solved in the other one ...

@3294318 can avoid double posting in the future? Double posting generally gives less answers and more unfollowed threads, and it's the same people anyway most of the time around the few spaces on BI & co.

So close this thread (as I guess you can't delete it).