Power BI. Combine 2 legends in bar chart

Question

I have 2 tables:

This is the relationship between the tables.

This is the Channel table

This is the Feedback table

This is the visualization

Basically, on the barchart, I am required to combine Fax and Mail together because Fax is kind of obselete. However, if I were to merge the two rows together, then the relationship link between the tables wouldn't work. Is there any way I can do this?

Answer 1

You could add a Calculated Column to the Channel Table:

Report Name = 
IF ( 
    Channel[Name] IN { "Mail", "Fax" },
    "Mail / Fax",
    Channel[Name]
)

Then use that Report Name field for your chart legend