change text in legend

[swong]

Hi,

I have these two tables:

I want to be able to visualize revenue for all the advertisers contained in Table 1 along with the subset of advertisers in Table 2. I can do this by visualizing revenue and date in a line graph and using Start Month as the legend:

Is there a way for me to change the legend text for "(Blank)"? Since it's not an actual column, I don't really have something to rename, and I don't know how to transform that value.

[v-yulgu-msft · Accepted solution]

Hi @swong,

It looks like there existing some rows in Table1 that aren't referenced to Start Month value in Table2. So, when you add [Start Month] in legend, (Blank) appears as a legend item. It is not available to rename the legend items, but you could try below workarounds.

In Table1, create a calculated column. In my test, I set the data type of Table2[Start Month] to text. If in your scenario, its data type should be date/time, then, you have to replace the "other Date" in below forlumn with a specific date value like Date(2017,1,1). In the chart, add Table1[Column] into legend area.

Column =
IF (
    RELATED ( Table2[Start Month] ) <> BLANK (),
    RELATED ( Table2[Start Month] ),
    "other Date"
)

Alternatively, if you only want to show values whose corresponding start month is not blank, you could create a new table to filter out some rows. Then, please create chart based on this new table.

Table =
ADDCOLUMNS (
    CALCULATETABLE (
        Table1,
        FILTER ( Table1, RELATED ( Table2[Start Month] ) <> BLANK () )
    ),
    "Start Month Column", RELATED ( Table2[Start Month] )
)

Best regards,
Yuliana Gu

[swong]

Thanks! The first solution worked perfectly.