Line chart based on measures - How can I make the legend respond on the choice

[M_MELLEMA]

I made a line chart based on measures, with a slicer that also shows the data based on measures.

For example, if I choose Aantallen, this is what you will see:

If I were to click on Bedragen, you would get a different overview. That works fine.

What I can't get is that the Legend also changes based on the choice you make.

When I choose Aantallen, I only want to see the legend of Aantallen and not the percentages and bedragen.

The legend is based on the measures I placed on the y-axis.

How can I make sure that in the legend, which is based on the measures in the y-axis, I only see the legend that belongs to the choice I make?

[M_MELLEMA · Accepted solution]

I've fixed it on a differt way with bookmarks.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Anonymous]

Hi @M_MELLEMA 

You'll need to put the category field in the "legend" box, I've made an example PBIX to help you understand.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[M_MELLEMA]

Hi Jayleny,

The category is a created table:

I've tried to put Weergave to the legend field, but I can't put it there.