How do I "hide" a column from the legend?

[MExtross]

Hello!

I am creating a line graph of data from 2013 to 2017 on a monthly basis and in order to get the month to be in the desired order, I had to create a new column with the month number. Now the sum of number is in the legend but not needed. I have changed the colour to white, but would prefer to completely hide it from the legend. Is this possible.

I have included a picture of the graph for your reference.

Thank you.

[TomMartens · Accepted solution]

Hey,

to get what you wanted

• go to the data view
• switch to the Modeling menu
• mark the column that contains the month name you are using in your visual
• from the ribbon use "Sort by column" and select the column you want to use to sort your montn name. please be aware that every instance of your month must have the same value

Hope this helps

Regards

Tom

[TomMartens · Accepted solution]

Hey,

to get what you wanted

• go to the data view
• switch to the Modeling menu
• mark the column that contains the month name you are using in your visual
• from the ribbon use "Sort by column" and select the column you want to use to sort your montn name. please be aware that every instance of your month must have the same value

Hope this helps

Regards

Tom

[MExtross]

Hi Tom,

Thanks for replying. I followed your instructions but the sum of number is still showing up in the legend.

Do you have any other ideas.

Thanks,

Maegan

[TomMartens]

Just remove the value that contains the month numbers from the visual

[MExtross]

@TomMartens

Unfortunately, without that extra column, the months go out of order. This was the only fix I could find for that...

[TomMartens]

Hey,

the "Sort by Column" is the way how the distinct values of a column used on an axis of a visual are ordered, for this reason I guess that the process I mentioned above is a little flawed.

Can you share your PBIX file or sample data that allows to recreate your issue.

Here are some screenshots

I'm going to sort the values of the column Month Name by another column, to make sure that my visuals start with January and not with February (the default order is alphabetically)

The next screenshot shows that the column Month Name is sorted by the values of the column Month No 

Each occcurence of January is matched by 01 no matter of the year.

And this is the result

If this gives you an idea than please share some sampledata that allows to recreate your issue, as I already mentioned above.

Regards

Tom

[KHorseman · Accepted solution]

If you've already properly set up the Sort by Column as he explained, go to the little ... icon in the upper right hand corner of your chart and change what the chart is sorted by.

[MExtross]

Ahh okay, now I am able to remove the extra column. Thank you!

[Dog]

Hi @MExtross

the screen shot makes this look like a title on the legend, just double check the format tab and the legend section and make sure title is turned off 

Dog

[MExtross]

Hi @Dog,

Thanks for replying! I checked that and turned the title off but there is no change...

And it might look like that just because I changed the data colour to white.

Maegan