Solved: Custom Legends...

NotMyJob · ‎01-14-2025

All,

I want a Line & Stacked clustered column chart, however I don't want duplicates of the data labels AND duplilcates in the Legend.

Here's what I'm getting:

Any ideas or can this even be done? It seems like it would be pretty simple... but no. (at least for now...)

Thanks anyone!!

danextian · ‎01-14-2025

Hi @NotMyJob

Under data labels, you can manually turn on/off the label for each series

For the legends, a series cannot be manually removed from it. You can however duplicate the visual, disable the legend from the original, remove the series that need to be excluded from the duplicate, turn off responsive, resize the duplicate and layout the two visuals so they look lke one.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

danextian · ‎01-14-2025

Hi @NotMyJob

Under data labels, you can manually turn on/off the label for each series

For the legends, a series cannot be manually removed from it. You can however duplicate the visual, disable the legend from the original, remove the series that need to be excluded from the duplicate, turn off responsive, resize the duplicate and layout the two visuals so they look lke one.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.